sofox wrote:
Message: Multi-statement transaction required more than
'max_binlog_cache_size'
bytes of storage; increase this mysqld variable and try again
Why don't you try doing what it suggests?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
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 S