Mysql/MariaDB tool for re-sync, copy and upgrate databases from one server to another.
- Add with mysql_config_editor all your --login-path, source and destination
- make sure you have a default mysql client configuration in ~/.my.cnf
- have manual backups of your database.
$ git clone git@github.com:caherrera/mysqloffsync.git
$ ~/mysqloffsync
your execute file will be in $ ~/bin/mysqloffsync
$ composer require caherrera/mysqloffsync
your execute file will be in
$ ./vendor/bin/mysqloffsync
Before to start to use the software you will need to configurate some stuff
- Setup your login-path in mysql
$ mysql_config_editor set --login-path=production.server.local --user=db_owner --password
$ mysql_config_editor set --login-path=dev.server.local --user=db_owner --password
- Next set up your mysqloffsync.ini file
$ mysqloffsync --setup
- And edit your file using your favorite editor
vim ~/.mysqloffsync/mysqloffsync.ini
$ mysqloffsync -?
$ mysqloffsync
$ mysqloffsync v|r|f
$ mysqloffsync v view_prefix_% v_list1 v_list2