-----Original Message-----
From: duncanh@stripped
To: mysql@stripped
Sent: Thu, 1 Mar 2007 6:01 AM
Subject: Re: Breaking Up Tables
>Otherwise you're looking at perhaps select limit 0,1000, 1000,1000, 2000,1000
>etc ..
Can you clean up this command? I can't find documentation on the select limit part of a
mysqldump command.
mysqldump --databases MyDatabase [MyTable] select limit 0,100 > MyTable.sql
When I tried this:
mysqldump --databases MyDatabase [MyTable select limit 0,100] > MyTable.sql
mysql complained it couldn't find a *database* named MyTable, but that's supposed to be
the table for which to look within the given database. And for that, I thought I was
following the rules just fine:
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
TIA,
Tony
________________________________________________________________________
AOL now offers free email to everyone. Find out more about what's free from AOL at
AOL.com.
