Limiting the number of records from mysqldump?

Article Number: 20 | Rating: Unrated | Last Updated: Fri, Sep 11, 2020 at 12:47 AM

mysqldump -u root -p --opt --where="1 ORDER BY id DESC LIMIT 0, 10000" database the_table > the_table_10k.sql

Reference:

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

Article Rating (No Votes)

Rate this article

Attachments

There are no attachments for this article.

Comments

There are no comments for this article. Be the first to post a comment.

Viewed 576 times since Mon, Sep 7, 2020