Re: Moving large Innodb table to another mysql

2006-11-17 Thread Visolve DB Team
Hi, Why can't you try copying the data directory itself to the target server? usually data directory resides in, for windows C:\Program Files\MySQL\MySQL Server 5.0\data for Unix & Linux -/usr/local/mysql, /var/lib/mysql respectively. or from the path where you installed mysql. Thanks ViSolv

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