-----Original Message-----
From: [EMAIL PROTECTED]
To: [email protected]
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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
