dbname.sql but what if I need entries from a string from...">Geek Answers HandbookMaximum mysqldump entries betweenmysqldump --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?+5mysql mysqldumpChandan gupta Aug 17 '11 at 12:41source share1 answerthere --whereit looks like a sql input request,however convenientmysqldump --opt --where="1 ORDER BY id LIMIT 2000, 1000" dbname > dbname.sql +5ajreal Aug 17 '11 at 12:52source shareMore articles:Как настроить заголовок с помощью метода http post - androidHow to animate a popup from bottom to top in android - androidMYSQL temp tables - view active - mysqlHow do you update attributes in an instance method in a rail model without using different variable names? - ruby | fooobar.comCode Analysis VS2010. Suppress message CA1051: DoNotDeclareVisibleInstanceFields for all class members - visual-studioDisplay html page and save it using command line - linuxHow to print_r $ _POST array? - variablesMongodb creates an alias in the request - mongodbHow to add personalized error messages to the Hibernate validator - hibernate-validatorDoes my code work on hackintosh? - testingAll Articles
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?
there --whereit looks like a sql input request,however convenient
--where
mysqldump --opt --where="1 ORDER BY id LIMIT 2000, 1000" dbname > dbname.sql