Changes between Version 7 and Version 8 of GROUPReplicate2

Timestamp:

06/14/22 21:30:23 (3 years ago)

Author:

krit

Comment:

--

GROUPReplicate2

@@ -96 +96 @@
 mysql> INSERT INTO products(product_name) VALUES("Shoes"),("Shirt"),("Trouser");
 }}}
+
+11. mysqldump and restore, pls login to '''docker exec -it node1 bash''' to get in a bash shell, then mysqldump a database '''testdb''' to a file on upper directory that we mount.
+{{{
+rpl_user@node1:/mysql/bin$ ./mysqldump -uroot --protocol=socket  --set-gtid-purged=OFF --socket=/tmp/mysql.0.sock testdb > ../testdb.sql
+}}}
+
+12 restore with
+{{{
+rpl_user@node1:/mysql/bin$ ./mysql -uroot --protocol=socket --socket=/tmp/mysql.0.sock testdb < ../testdb.sql
+}}}