Tuesday, April 30, 2013

Limiting the number of records from mysqldump?

http://stackoverflow.com/questions/135835/limiting-the-number-of-records-from-mysqldump

mysqldump -h hostname -u user --quick --where="1 limit 1000000" myDatabase > out.sql


mysql --force -h hostname -u user --password=password myDatabase < out.sql

No comments: