How to export databases through command line?

问题:

I have URL of phpMyAdmin, I have username and password. How can I export all those databases? Because phpMyAdmin crashes when I try to export them, so I want to try it through command line.

回答1:

mysqldump -uUSERNAME -pPASSWORD -hHOSTNAME USER_DATABASE > FILENAME.sql

Then import using:

mysql -uUSERNAME -pPASSWORD -hHOSTNAME USER_DATABASE < FILENAME.sql

回答2:

mysqldump -u user -p db_name > db_file.sql

Edit: based on the comments on another answer.

If MySQL server allows for remote connections, then you can run this command on another machine you do have access to.

mysqldump -h hostname-of-your-server -u user -p db_name > db_file.sql

回答3:

If you want to export all databases at a single command at the same time, use the following command instead.

mysqldump -u <THE USERNAME> -p --all-databases > all_databases.sql