mysql backup

[svar]

i have a mysql database in mysyatem, i want to take backup and transfer it to another database, how it can be done.

[countach44]

you can use mysqldump:

mysqldump -u USER -p DATABASE > file.sql

will login as USER (and prompt for password) and dump the contents of DATABASE to file.sql

Then on the new server, run:

mysql -u USER -p DATABASE < file.sql

Make sure the charsets match, I've had troubles with this when going from different versions of mysql.

[svar]

It works, Thanks..