mysqldump 使用

示例1：备份mytest库中的student表

mysqldump -uroot -p'123456' mytest student > /mnt/table_bak/student_bak.sql

示例2：备份mytest库中所有表，就是备份mytest库

mysqldump -uroot -p'123456' mytest > /mnt/table_bak/all_bak.sql

示例3：备份mytest库中的student和test表

mysqldump -uroot -p'123456' mytest student test > /mnt/table_bak/two_bak.sql

示例4：-d参数，只备份表结构

mysqldump -uroot -p'123456' -d mytest stusent > /mnt/studentDesc_bak.sql

示例5：-t参数，只备份数据

mysqldump -uroot -p'123456' --compact -t mytest stusent > /mnt/studentData_bak.sql

INSERT INTO `student` VALUES (1,'Tom',20,'S11'),(2,'Jary',21,'S12'),(3,'King',25,'S10'),(4,'Smith',19,'S11'),(5,'??',20,'S11'),(6,'张三',20,'S11');

 

 

 

yum -y install holland-mysqldump.noarch

//数据导出

./mysqldump.exe -h 192.168.1.1 -P 3306 -u user -p111111 --single-transaction --default-character-set=utf8 aiplot_bb | gzip > /h/aiplot_bb.sql.gz

 

//文件导入

./mysql.exe -h localhost -P 3306 -u user -p111111 --default-character-set=utf8 aiplot_system < /h/aiplot_bb.sql/aiplot_bb.sql