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

Reply via email to