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