Hi Vic, May be that is the type of life in a cluster, how did you restart you node after restoring backup: did you tell the system it’s a new cluster ?
/svar Stéphane Varoqui, Senior Consultant Phone: +33 695-926-401, skype: svaroqui http://www.mariadb.com <http://www.mariadb.com/> > Le 19 Dec 2016 à 22:25, l vic <lvic4...@gmail.com> a écrit : > > i have installed mariadb 1.10.13 cluster with user "root", password "pass" > I have created test database "galeratest": > CREATE DATABASE galeratest; > USE galeratest; > CREATE TABLE test_table ( > id INT PRIMARY KEY AUTO_INCREMENT, > msg TEXT ) ENGINE=InnoDB; > INSERT INTO test_table (msg) > VALUES ("Hello cluster."); > > backup: > xtrabackup --user=root --password=pass --backup --target-dir=/media > 161219 21:06:00 version_check Connecting to MySQL server with DSN > 'dbi:mysql:;mysql_read_default_group=xtrabackup;port=3306;mysql_socket=/var/run/mysqld/mysqld.sock' > as 'root' (using password: YES). > 161219 21:06:00 version_check Connected to MySQL server > 161219 21:06:00 version_check Executing a version check against the server... > ... > ok > .. > At this point i drop my database : DROP DATABASE galeratest; > and trying to restore: > xtrabackup --user=root --password=pass --prepare --target-dir=/media > > > cd /media/ > rsync -rvt --exclude 'xtrabackup_checkpoints' --exclude 'xtrabackup_logfile' \ > ./ /var/lib/mysql > chown -R mysql:mysql /var/lib/mysql/ > > MariaDB [galeratest]> show tables; > +----------------------+ > | Tables_in_galeratest | > +----------------------+ > | test_table | > +----------------------+ > 1 row in set (0.00 sec) > > MariaDB [galeratest]> select * from test_table; > > ERROR 1932 (42S02): Table 'galeratest.test_table' doesn't exist in engine > Any idea what the problem is? > Thanks, > _______________________________________________ > Mailing list: https://launchpad.net/~maria-discuss > Post to : maria-discuss@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
