MySql Database Help Please
 

I have a backup of my database and I need to restore it to a new MySql DB on another server. All of the Tables are already created and I dont' want to dump and recreate the DB. I just want to populate the new DB with the old DB's info.

Any help would greatly appreciated.


:helpme

you got SSH access?

what he said

Yes, ssh

mysql -uUSERNAME -p dbname < /path/to/dump.sql



this script will work too but the above command is easier

http://www.ozerov.de/bigdump.php

Yes but when I do that command it says the table has already been created which it has. I'm worried about breaking something in the software that connects to it and would prefer to just insert the data from the old backup.

How did you backup the old database?

Well I would just rename the database you have there now then recreate it. Becasue hte backup you have is always going to try to recreate the tables unless you go in with a txt editor and remove all the table creation statments.

I highly doubt an unavialbe databse would "Break" any scripts.

I just dumped it. no special flags, maybe I'm just going to have to drop all the tables in the new DB and restore it.

Ok, thanks gusy. I'll backup this one restore the old one and see what happens. It should be fine.

Thanks for jumping in and helping me so quickly.

You guys are too cool.:thumbsup :thumbsup