MySQL limited records in mysqldump

mysql

When I wanted to mysqldump a limited amount of records, I used the below command to limit my mysql dump to just 1 million records.

mysqldump -uroot -hsome-db02 -P3313 a_shard_07 table –where=”TRUE ORDER BY table_id LIMIT 1000000″ | gzip -c | cat > /db/disk/myDump.sql.gz

Leave a Reply

Your email address will not be published. Required fields are marked *