Public bug reported: Binary package hint: mysql-server
Both client and server are version 5.0.22-Debian_0ubuntu6.06-log 1. Setup replication as per instructions at http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html 2. Log in the client as root and run LOAD DATA FROM MASTER 3. Check warnings. This bug is MySQL bug #18607, and is reported fixed in 5.0.22: http://bugs.mysql.com/bug.php?id=18607 $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 60 to server version: 5.0.22-Debian_0ubuntu6.06-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> LOAD DATA FROM MASTER; Query OK, 0 rows affected, 1 warning (0.01 sec) mysql> SHOW WARNINGS; +-------+------+-------------------------------------------------------------+ | Level | Code | Message | +-------+------+-------------------------------------------------------------+ | Error | 1007 | Can't create database 'information_schema'; database exists | +-------+------+-------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> ** Affects: mysql-dfsg-5.0 (Ubuntu) Importance: Untriaged Status: Unconfirmed -- LOAD DATA FROM MASTER fails https://launchpad.net/bugs/55682 -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs