On Thursday 01 March 2007 09:56:41 [EMAIL PROTECTED] 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 .. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
