Restore command of MySQLBackuper backuper may restore the wrong database
------------------------------------------------------------------------
Key: SEQUOIA-939
URL: https://forge.continuent.org/jira/browse/SEQUOIA-939
Project: Sequoia
Type: Bug
Components: Backup System
Versions: Sequoia 2.10.6
Reporter: Mathieu Peltier
Assigned to: Mathieu Peltier
Priority: Critical
Fix For: Sequoia 2.10.7
Workaround: make sure that same real database name is used for all backends of
a given database.
Test case:
controller 1 (192.168.0.100)
colocated backend db3
remote backend db4 (192.168.0.102)
- Backend backend [EMAIL PROTECTED] into
/opt/archive/mcluster/db1_vbtest_com_Dump_1
- Print content of [EMAIL PROTECTED]:
[EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
--password=realpass db3
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 72 to server version: 4.1.21-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+---------------+
| Tables_in_db3 |
+---------------+
| foo2 |
+---------------+
2 rows in set (0.00 sec)
- Restore dump on [EMAIL PROTECTED]:
[EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
--password=realpass db4 < /opt/archive/mcluster/db1_vbtest_com_Dump_1
- [EMAIL PROTECTED] has being restored instead of [EMAIL PROTECTED]: <-- ERROR
[EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
--password=realpass db3
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 74 to server version: 4.1.21-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
+---------------+
| Tables_in_db3 |
+---------------+
| foo2 |
+---------------+
1 row in set (0.00 sec)
[EMAIL PROTECTED] ~]# mysql -h 192.168.0.102 --port=3306 -urealuser
--password=realpass db4
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 75 to server version: 4.1.21-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show tables;
Empty set (0.00 sec)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
