Re: Breaking Up Tables

[Duncan Hill]

On Thursday 01 March 2007 09:56:41 tonylabarbara@stripped wrote:
> Hi;
> I have an unusual problem. My current production server's OS is corrupt and
> I'm building a new one. However, due to the corruption, I can't move files
> out of it. I have a "back door" through Zope, but I can only move files of
> a certain size (I don't know how large ;). I need to back up a certain
> database. All the "weight" of the database is in one table. Doing a
> mysqldump of that table results in a file too big to transfer. Is there a
> way to break up that table, do various dumps, and then reassemble it? TIA,

If you can execute SQL remotely, you can always run a query and dump to 
another file system.  mysqldump can also run remotely, and be piped right 
back into mysql on the local system.

Otherwise you're looking at perhaps select limit 0,1000, 1000,1000, 2000,1000 
etc ..