Found the problem: didn't shutdown mysqld before i attempted restore On Mon, Dec 19, 2016 at 7:02 PM, Stephane VAROQUI <[email protected]> wrote:
> 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 > > Le 19 Dec 2016 à 22:25, l vic <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp > > >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
