MySql Database Help Please

[soldierdog]

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.

[- Jesus Christ -]

you got SSH access?

[com]

Originally posted by - Jesus Christ -
you got SSH access?

what he said

[soldierdog]

Yes, ssh

[- Jesus Christ -]

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

[soldierdog]

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.

[goBigtime]

How did you backup the old database?

[- Jesus Christ -]

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.

[soldierdog]

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.

[soldierdog]

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.