maria-discuss team mailing list archive

[Stephane VAROQUI <stephane@xxxxxxxxxxx>]

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 <lvic4594@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp