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 ViSolve DB Team. ----- Original Message ----- From: "sofox" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> 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) . > > 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 more > than 10 hours to import the script; > 2) if I use --no-autocommit option during dump, I will get error > # Error: 1197 SQLSTATE: HY000 (ER_TRANS_CACHE_FULL) > Message: Multi-statement transaction required more than > 'max_binlog_cache_size' > bytes of storage; increase this mysqld variable and try againAny > Comment?Oscar Yen.Select >
