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:
Post a Comment