dbname.sql but what if I need entries from a string from...">

Maximum mysqldump entries between

mysqldump --opt --where="true LIMIT 100" dbname > dbname.sql

but what if I need entries from a string from 2000 to 3000? as in general sql we can use LIMIT 2000, 3000; but are there any similar alternatives for mysqldump?

+5
source share
1 answer

there --whereit looks like a sql input request,
however convenient

mysqldump --opt --where="1 ORDER BY id LIMIT 2000, 1000" dbname > dbname.sql
+5
source

All Articles