Limiting the number of records from mysqldump?

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 ID: 20
Created On: Fri, Sep 11, 2020 at 12:47 AM
Last Updated On: Fri, Sep 11, 2020 at 12:47 AM
Authored by: Saeed Nobakht [[email protected]]

Online URL: https://www.navel.ir/article/limiting-the-number-of-records-from-mysqldump-20.html