MySQL large capacity database backup method

It can be used on VPS and virtual hosts that support SSH. It is convenient and fast. The command is as follows:

To export the database, you need to use the MySQL mysqldump tool. The basic usage is:
shell> mysqldump [OPTIONS] database [tables]
If you don't give any tables, the entire database will be exported.
1. Export the entire database
mysqldump -u username -p password database name> exported file name
/usr/local/mysql/bin/mysqldump -uroot -ppassword wordpress | gzip -9 –> wordpress_db.sql.gz
2. Export a table
mysqldump -u username -p password database name table name > exported file name
/usr/local/mysql/bin/mysqldump -uroot -ppassword wordpress wp_config> wordpress_wp_config.sql
3. Import the database using the source command to enter the MySQL database console. The command is
mysql -u username -p password
/usr/local/mysql/bin/mysql -uroot -ppassword
Select Database
mysql>use database and then use the source command, followed by the .sql file
mysql>source 123.sql
After the import is complete, use exit to exit the MySQL database console.

Reprinted from: http://www.zhukun.net/archives/4893