How do I manually export or "dump" a MySQL database from command line or SSH?
You can dump a MySQL database to the current folder from an SSH session using the following command:
mysqldump –no-create-db=true -uUSERNAME -pPASSWORD DATABASE > filename.sql
So if your database name is "USER_MYDATABASE" and your database username is "USER_USER1" and the password is "PASSWORD1" and you would like to save the dump as "mydump.sql", you would use the following:
mysqldump –no-create-db=true -uUSER_USER1 -pPASSWORD1 USER_MYDATABASE > mydump.sql