Home » Categories » MySQL » Command Line | ||||
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 |
||||
| ||||
Attachments
![]()
There are no attachments for this article.
| ||||
Comments ![]() There are no comments for this article. Be the first to post a comment. | ||||
MySQL OPTIMIZE & Repair all tables in one go
Viewed 416 times since Mon, Sep 7, 2020
|