[ https://forge.continuent.org/jira/browse/SEQUOIA-939?page=all ] Mathieu Peltier closed SEQUOIA-939: -----------------------------------
Tested > 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 > Assignee: 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
