Contents from one MySQL to another?

[gunhoe86]

Can someone help me with a MySQL code that esentially would allow me to copy and paste the info. from one database to another? We can't get ahold of the engineers to access some missing files, but we can run SQL queries and hopefully copy the old database to a new one.

Is this even possible?

Thanks,

~JOSH

[rachel2004]

What you want to do is run mysqldump. It will dump the contents of the database you specify into a file which can then be imported back into MySQL either on that same server or on a different server.

Check the MySQL manual for exact syntax but it's basically like this if you're on a UNIX/Linux box:

mysqldump db_name > /usr/local/db_dump.sql -u username password=your_password_here

Your run it from the MySQL directory.

[rachel2004]

I should mention: when you're ready to import your dump file, you do it with just the "mysql" command:

mysql db_name_to_import_into < /usr/local/dump_file.sql -u username -p

You'll be prompted for your password. It may be necessary for you to create the database name before you execute the above command. Otherwise, I believe MySQL gives you an error message about the database not being found or not existing. Same thing.

To create a database, execute the following from within the MySQL monitor

create database db_name;

Remember, that's done from within the MySQL monitor (or equivalent if you're using a third party tool like phpmyadmin).