How to back up the database under SSH using common Linux commands

For Linux system vps hosts, the management panel is often installed, which is very simple to operate, and simple security is also set up! Papmyadmin is often used to export and backup the database. If you encounter that phpmyadmin cannot be opened, or other situations where you cannot directly operate mysql, directly use the ssh command to back up mysql. The command is as follows:

mysqldump -h localhost -p db_name -u db_username > /home/wwwroot/xxx.sql

Code Description:
localhost is the database address;

db_name is the database name;

db_username is the database user name;

/home/wwwroot/xxx.sql is the location where the database backup will be saved.

Make modifications according to the code instructions. Generally, the localhost remains unchanged. The subsequent modifications are based on the name of your own database and Lu Jin. Different management panels have different Lu Jin!

Enter this command and press Enter. The system will ask for the password of the database user. Just enter it and press Enter.

Recommended site searches: dual-line server hosting, Chinese domain name registration, Ministry of Industry and Information Technology filing, how much does server defense cost, the price of overseas server rental, Yangzhou dual-line server Hong Kong server defense, domain name expiration query, website domain name query, mainland China permanent Free cloud server,