Re: Breaking Up Tables

[Fagyal Csongor]

>-----Original Message-----
>From: duncanh@stripped
>To: mysql@stripped
>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 to create mysqldump files
> of *parts* of a table in a database, because the entire table is just too big to move
> under the current circumstances. So, the end result should be a bunch of little mysqldump
> files that are each a part of this table in this database. Then I need to be able to
> rebuild the table by inserting the parts. Can you suggest a way to do that?
>  
>
Don't think about moving a file - think about pipeing the output of mysqldump into another
mysql.

IMHO you should be able to do something like (executing on the machine where you want to
create your new tables):

mysqldump --host=remote_ip database_name (other parameters) |mysql (local parameters)
database_name

Of course using the parameters you need (e.g. -p, -u, etc...)

But this is in the manual of mysqldump (on the other way around) : 

"
mysqldump is also very useful for populating databases by copying data       from one
MySQL server to another:
shell> mysqldump --opt db_name | mysql --host=remote_host -C db_name
"

- Fagzal