Database dump syntax ?

[oldlock]

Can anyone please advise the correct syntax to :

Backup an existing database by SSH and write the resulting file to the server where it can then be retrieved via FTP ?

TIA

 

[cPanelMichael]

Hello

You can use the mysqldump utility. EX:

mysqldump database_name > /path/to/database.sql

Thank you.

 

[oldlock]

That threw back an error - should there be a password in that string ??

 

[Infopro]

Try this:

mysqldump --opt -Q -u dbUsername_dbUsername -p dbUsername_dbName > /path/to/save/bu/to/backupname.sql

Type in password when asked.

 

[oldlock]

That worked perfectly. Very quick too. Thanks.