Breaking Up Tables

2007-03-01 Thread tonylabarbara
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

Re: Breaking Up Tables

2007-03-01 Thread Duncan Hill
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

RE: Breaking Up Tables

2007-03-01 Thread Tim Lucia
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 4:57 AM To: mysql@lists.mysql.com Subject: Breaking Up Tables Hi; I have an unusual problem. My current production server's OS is corrupt and I'm building a new one. However, due

Re: Breaking Up Tables

2007-03-01 Thread tonylabarbara
-Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com 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

Re: Breaking Up Tables

2007-03-01 Thread Duncan Hill
On Thursday 01 March 2007 13:43:38 [EMAIL PROTECTED] wrote: 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. It's nothing to do with mysqldump -

Re: Breaking Up Tables

2007-03-01 Thread tonylabarbara
-Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:00 AM Subject: Re: Breaking Up Tables It's nothing to do with mysqldump - it's part of the SELECT syntax for regular queries. Then I'm confused as to what you're suggesting I do. I need

Re: Breaking Up Tables

2007-03-01 Thread Fagyal Csongor
-Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:00 AM Subject: Re: Breaking Up Tables It's nothing to do with mysqldump - it's part of the SELECT syntax for regular queries. Then I'm confused as to what you're suggesting I do. I

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread Eugene Mah
[EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:00 AM Subject: Re: Breaking Up Tables It's nothing to do with mysqldump - it's part of the SELECT syntax for regular queries. Then I'm confused as to what you're

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread tonylabarbara
-Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:35 AM Subject: Re: [inbox] Re: Breaking Up Tables if you have shell access on the server, why not just use split? Create your big dump file, split it into smaller chunks and use cat

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread Aaron Cannon
] To: mysql@lists.mysql.com Sent: Thursday, March 01, 2007 9:15 AM Subject: Re: [inbox] Re: Breaking Up Tables -Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 10:35 AM Subject: Re: [inbox] Re: Breaking Up Tables if you have shell access

RE: Breaking Up Tables

2007-03-01 Thread Gary W. Smith
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

Re: [inbox] Re: Breaking Up Tables

2007-03-01 Thread tonylabarbara
-Original Message- From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thu, 1 Mar 2007 11:47 AM Subject: Re: [inbox] Re: Breaking Up Tables Hope this helps. Sure does! Thanks a bunch :)) Tony AOL now offers