Dear All, I have a very large table(>10G) in innodb, and I want move it to another mysql server.
Of cause, mysqldump --quick mydb mytable > mytable.sql && mysql -h newhost newdb < mytable.sql can do this for me, except: 1) if I use --no-autocommit while dumping, 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 again when I import mytable.sql 2) if no --no-autocommit, it will take >10 hours to import the sql on my dual xeron 3.0G/2G memory box Any good idea? Oscar Yen. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
