The mysqldump command is used to back up databases.
The mysqldump command is executed in the DOS [url=file://mysqlbin]mysqlbin[/url] directory.
1) Export the entire database (the exported file is stored in the mysqlbin directory by default)
mysqldump -u username -p database_name > exported_file_name
mysqldump -u user_name -p123456 database_name >
outfile_name.sql
2) Export a table
mysqldump -u username -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 adds 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, to back up the aaa database to the file back_aaa:
[[email protected]
root]# cd /home/data/mysql
[[email protected]
mysql]# mysqldump -u root -p –opt aaa > back_aaa
2. Import the database
1. First create an empty database
mysql>create database abc;
2. Import the database
Method 1:
(1) Select the database
mysql>use abc;
(2) Set the database encoding
mysql>set names utf8;
(3) Import the data (note the path of the SQL file)
mysql>source /home/abc/abc.sql;
Method 2:
mysql -uusername -ppassword database_name < database_name.sql
#mysql -uabc_f -p abc < abc.sql