Mysql数据迁移命令mysqldump

mysql 数据迁移命令 备份database库table表中id大于22的数据，SQL如下

mysqldump -u test -ptest database table --default-character-set=gbk -t --where="id>22" >c:\test.sql  

将年龄大于三十的同学的信息备份出来

mysql> select * from students where Age > 30 into outfile ‘/tmp/stud.txt' ;   
mysql> load data infile '/tmp/stud.txt' into table students;