| KB Home | Advanced Search | News | Glossary | Login |
|
| Navel Knowledge Base |  |
|
|
Command Line Articles   Subscribe
Limiting the number of records from mysqldump?
Viewed 744 times since Fri, Sep 11, 2020
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 Read More
MySQL OPTIMIZE & Repair all tables in one go
Viewed 576 times since Mon, Sep 7, 2020
mysqlcheck -o --all-databases -u root -pmysqlcheck -o <db_name> -u root -p=================================================mysqlcheck --auto-repair --check --all-databases -u root -p mysqlcheck --auto-repair --databases <db_name> -u... Read More
|
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)
;)