mysqldump -uroot --opt --where="1 limit 2, 3" dbname --no-create-info > bk.sql
I use this command to dump partial data of database or dump large database to multiple files and it works well.
As I tested,
2 means skip first 2 recoreds,
and 3 means dump 3 records,
but I don't understand 1 means what in --where="1 limit 2, 3"?
Aucun commentaire:
Enregistrer un commentaire