Backing up a database using mysqldump

2. Backing up a database using mysqldump
6. 1. Backing up a database
10. mysqldump--user [user name] --password=[password] [database name] > [dump file]
12. Or
14. Mysqldump-u[user name]-p[password] [database name] > [dump file]
18. Example:
22. mysqldump--user root --password=myrootpassword db_test > Db_test.sql
24. Or
26. Mysqldump-uroot-p Myrootpassword db_test > Db_test.sql
30. 2. Backing up multiple databases
34. Mysqldump-u[user name]-p[password] [database name 1] [database name 2]. > [dump file]
38. Example:
42. mysqldump--user root --password=myrootpassword db_test db_second db_third > Db_test.sql
46. 3. Back up all databases
50. mysqldump-u [user Name]-p [password]--all-databases > [dump file]
54. 4. Back up a table
58. Mysqldump--user [username] --password=[password] [database name] [table name]/tmp/sugarcrm_accounts_contacts.sql
62. Example:
66. mysqldump--user root --password=myrootpassword db_test customers db_test_customers.sql
70. 5. Recovering a Database
74. MySQL--u [username] --password=[password] [database name] < [dump file]
78. Example:
82. MySQL--user root --password=myrootpassword new_db < db_test.sql

The mysqldump command is used to back up the database.

The mysqldump command executes under the DOS [Url=file://\\mysql\\bin]\\mysql\\bin[/url] directory.

1) Export the entire database (the export file is present in the Mysql\bin directory by default)
Mysqldump-u user name-p database name > exported file name
Mysqldump-u user_name-p123456 database_name > Outfile_name.sql

2) export a table
Mysqldump-u user name-P database name Table name > exported file name
MYSQLDUMP-U USER_NAME-P database_name table_name > OUTFILE_NAME.SQL

3) Export a database structure
Mysqldump-u user_name-p-d–add-drop-table database_name > Outfile_name.sql
-D No data –add-drop-table add a drop table before each CREATE statement

4) Export with language parameters
mysqldump-uroot-p–default-character-set=latin1–set-charset=gbk–skip-opt database_name > Outfile_name.sql

For example, back up the AAA library to file Back_aaa:
[Email protected] root]# Cd/home/data/mysql
[Email protected] mysql]# mysqldump-u root-p--opt aaa > BACK_AAA

Backing up a database using mysqldump