maria-discuss team mailing list archive

[l vic <lvic4594@xxxxxxxxx>]

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,