Re: Moving large Innodb table to another mysql

2006-11-17 Thread Visolve DB Team
. Thanks ViSolve DB Team. - Original Message - From: "sofox" <[EMAIL PROTECTED]> To: Sent: Friday, November 17, 2006 5:32 PM Subject: Moving large Innodb table to another mysql > Dear All, > > I am using mysql-4.0.26, and I have a very large innodb table(>10G)

Re: Moving large Innodb table to another mysql

2006-11-17 Thread Dan Buettner
Sorry - what's your question? #1 will work, or you can increase the value for the variable named in the error message in scenario #2. Dan On 11/17/06, sofox <[EMAIL PROTECTED]> wrote: Dear All, I am using mysql-4.0.26, and I have a very large innodb table(>10G) . When I try to moved the tabl

Moving large Innodb table to another mysql

2006-11-17 Thread sofox
Dear All, I am using mysql-4.0.26, and I have a very large innodb table(>10G) . When I try to moved the table from one mysqld to another one by mysqldump to a script and import the script on target server, I have problem: 1) if I don't use --no-autocommit option when mysqldump, it will take mor