Import Question

[Indy]

OK, this may be a stupid question, but....

I want to dump my db, then import it again with a new db name. Obviously so that I can test my upgrade to vB3 before hand, etc.

Let's say that I dump a db named "forumdb"

By using this command: mysql testforumdb < backup-file.sql should I expect to see two db's, one called "forumdb" and one called "testforumdb"?

Secondary question: Isn't it recommended to disable the forums while a dump is taking place? If so, then setting up a cron job to dump your db would not seem feasable. Would you agree?

Thanks!
Dan

[Indy]

Well, I answered the first part. I didn't have my password with me at work today, but the minute I got home I did some testing. Yep, I can duplicate a db!

I know, sounds silly but until you do it the first time.......:o

Any comments on dumping with open forums are welcome though.


Thanks again!
Dan

[Steve Machol]

Ideally you should close your forums while backing them up. However since the tables are locked while they are being backed up, the likelihood of a major problem is almost nil. However the busier your forums are, the higher the potential problem.