...Some of my tables have thousands of records and I may only want the first 200 or so. I did not see an option on mysqldump that would limit the number of records. Any ideas without writing a program? Kevin >>>>>>>>>>>>> Try the WhereClause option in mysqldump. Syntax is: -w 'where_clause' -or- --where='where_clause'. Of course, 'where_clause' would be something like 'id<200' or whatever's appropriate. It's on page 620 of 'MySQL' by Paul DuBois (New Riders). Invaluable book, btw. Jay Fesco --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
- WANTED: Utility to reverse engineer existing database Kevin
- Re: WANTED: Utility to reverse engineer existing ... Peter van Dijk
- Re: WANTED: Utility to reverse engineer existing ... Colin Faber
- Re: WANTED: Utility to reverse engineer existing ... Jeremy Falcon
- Re: WANTED: Utility to reverse engineer existing ... j.urban
- WANTED: Utility to reverse engineer existing data... Kevin
- RE: WANTED: Utility to reverse engineer exist... Carsten H. Pedersen
- Re: WANTED: Utility to reverse engineer exist... j.urban
- Re: WANTED: Utility to reverse engineer exist... Michael Meltzer
- Re: WANTED: Utility to reverse engineer exist... Jay Fesco
- Re: WANTED: Utility to reverse engineer e... Stefan Hinz
- Re: WANTED: Utility to reverse engineer exist... Stefan Hinz
- RE: WANTED: Utility to reverse engineer exist... Don Read
- Re: WANTED: Utility to reverse engineer existing ... Stefan Hinz
- Re[2]: WANTED: Utility to reverse engineer existi... Mark A. Chalkley