Comments - Backup and Restore Overview
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi, I am facing a strange issue here. I have setup a galera cluster with 3 nodes. As long as I am creating database/tables/ adding data directly to any of the galera nodes, it works fine. But when I import a mysqldump created sql from another database -using command like
mysql -uroot -p testDB<testDB.sql
I face a strange issue. If I run import on primary node of the galera, i acn see data is imported properly on primary node. But when I try to verify the same on one of the secondary nodes, I realize that suddenly i am not allowed in using my old credentials. ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
On more investigation, i realize that mysql.user table has been emptied on secondary node.
MariaDB [mysql]> select * from mysql.user; Empty set (0.00 sec) (Ofcourse I had to start this node's mysql usng skip grant tables for this)
Can you please guide me what could be the issue here?
Just guessing, but: Galera Cluster only supports InnoDB tables. However, the mysql.* tables are using MyISAM. So the tables will be created OK on the node where you run the import, but replication to the other nodes will not work correctly.