I was experiencing difficulties getting replication working between
two identical Ubuntu 8.04 VMs for databases using InnoDB tables.
The error I was getting was:
'Access denied; you need the SUPER privilege for this operation'
despite the replication user being granted all privileges to all
databases on the master and slave.
I was unable to identify any cause for the problem, but after
removing the MySQL server package, reinstalling and configuring
replication from scratch, replication still failed because of
INSERTS after the recorded MASTER_LOG_POS before the dump was
taken were also appearing in the mysqldump.
This was caused by using --single-transaction with the dump.
The problem was resolved by using only --master-data=1 for the
mysqldump.
The databases are now correctly replicated to the slave.
Regards,
Julian
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System
on behalf of the London Business School community.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
