Mysql Export Partial Dump

Hi,

I've got a mysql database (records) that has a number of tables (table1, table2) in it. Some of the tables have millions of records in it.

Is it possible to make a mysqldump of the entire database that limits the records on each table within the database to the last 100 records?

something like:
mysqldump --where="true last 100" -u user -p pass records > out.sql
ecuguruAsked:
Who is Participating?
 
theGhost_k8Database ConsultantCommented:
yes, try:
mysqldump -u user -p pass --where="true LIMIT 100"  databasename > out.sql
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.