Perl Script to Dump MySQL Database

[robflack]

i'm moving my board to a new server. I need to take a dump of the database and give it to my host for them to populate my new database for me..

they suggested using a perl script to take the dump into the file.. could some please suggest an appropriate perl script to do the job..

Thank you

Rob Flack

[tgmorris]

Originally Posted by robflack

i'm moving my board to a new server. I need to take a dump of the database and give it to my host for them to populate my new database for me..

they suggested using a perl script to take the dump into the file.. could some please suggest an appropriate perl script to do the job..


Thank you

Rob Flack

Is there a reason not to use the mysqldump command via telnet or SSH? It works quite nicely and the output may be used to populate the new database if the right options are used.

I have a .my.cnf file set up with the needed info such as password and username. All that's needed is to run the following at the command prompt.

mysqldump --opt your.db.name.here > dumpfile.sql

Then, transfer the generated file to the new host and run this command (assumes that the .my.cnf file has been set up)

mysql your.new.db.name.here < dumpfile.sql

When finished you will have an exact copy of your original db.

The only caveat is that your host may have a restriction on how long the command can run. If you have a fair sized db it may exceed the time limit.