Wednesday, November 25, 2015

How to export with limit the number of records from mysqldump?

mysqldump --opt --where='1 limit 10' -h IP_ADDRESS -u USER_NAME DATABASE_NAME TABLE_NAME > databasetable.sql

No comments:

Post a Comment