Helloo Everyone,

I would like to copy a database so I can relocate it and the php pages onto another system. What command do I use to copy the database?

Thanks!

You need to dump the database data and table structures into a file. Then read that file into MySQL on the new server. I've never dumped using the command line, but check the mysql pages for detailed info and which options to use. To read back in, just use '<' or 'source' from the shell.

from:http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

Quite right: mysqldump is a right way to make copy of your database.

Hi,

Try to export the database through mysqldump or any available GUI's or check the option transfer database available in the major mySQL managers.


Regards,

This function does not seem to work.....do I log into mysql or do I complete this from shell? My datbase name is accm. Does that help?

From the shell:

mysqldump --opt accm > backup-file.sql

You may also need to specify the host, username, password, etc. Check out http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html for more info on that and which options you may want to use.

-bash mysqldump: command not found

How do I install this?

mysqldump should already be included. Make sure the MySQL bin directory is in your PATH environment variable. For bash, I believe the command to set is 'export'...:
export PATH=$PATH:/pathto/mysqlbin/
Or try running the command from the bin directory.

Besides mysqldump, could anyone tell me another methods to backup the entire database coz I might not know where the path of mysqldump is in other server. Thank you.