|
0 1 2 3 4 5 |
$ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="true limit 1000" > /tmp/a.sql Enter password: $ /usr/local/mysql/bin/mysqldump -uroot -p'' database table --where="id < 2052001" > /tmp/a.sql Enter password: mysqldump -uroot -p -h192.168.11.18 database-name --where="true limit 100" > /root/db.sql > select * FROM 表名 WHERE id > 24148614 and id < 24148619 into outfile "/tmp/ab.sql" ; #update mysql.user set File_priv=’Y’ where user=’xxxx’; |
申明：除非注明Byrd's Blog内容均为原创,未经许可禁止转载!详情请阅读版权申明!
