2017 © Pedro Peláez
 

library mysqloffsync

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

image

caherrera/mysqloffsync

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  • Wednesday, August 2, 2017
  • by caherrera
  • Repository
  • 1 Watchers
  • 0 Stars
  • 16 Installations
  • Shell
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 8 Versions
  • 0 % Grown

The README.md

mysqloffsync

Mysql/MariaDB tool for re-sync, copy and upgrate databases from one server to another., (*1)

Requirements

mysql, (*2)

Before start to use

  1. Add with mysql_config_editor all your --login-path, source and destination
  2. make sure you have a default mysql client configuration in ~/.my.cnf
  3. have manual backups of your database.

Installation

Clone this repo

$ git clone git@github.com:caherrera/mysqloffsync.git
$ ~/mysqloffsync

your execute file will be in $ ~/bin/mysqloffsync, (*3)

By composer

$ composer require caherrera/mysqloffsync

your execute file will be in, (*4)

$ ./vendor/bin/mysqloffsync

First Time

Before to start to use the software you will need to configurate some stuff, (*5)

  1. Setup your login-path in mysql, (*6)

    $ 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

  2. Next set up your mysqloffsync.ini file, (*7)

    $ mysqloffsync --setup

  3. And edit your file using your favorite editor, (*8)

    vim ~/.mysqloffsync/mysqloffsync.ini

Get some help

$ mysqloffsync -?

Usage

Copy all tables (default)

$ mysqloffsync

copy views|routines|functions

$ mysqloffsync v|r|f

copy some views

$ mysqloffsync v view_prefix_% v_list1 v_list2

The Versions

02/08 2017

dev-master

9999999-dev

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

25/07 2017

v0.3.4

0.3.4.0

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

21/07 2017

v0.3.2

0.3.2.0

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

21/07 2017

v0.3.3

0.3.3.0

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

20/07 2017

v0.3.1

0.3.1.0

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

20/07 2017

v0.3

0.3.0.0

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

20/07 2017

v0.2

0.2.0.0 https://github.com/caherrera/mysqloffsync

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

mysql sync mysqldump

20/07 2017

v0.1

0.1.0.0 https://github.com/caherrera/mysqloffsync

this is a simple wrapper tool with some extras to mysqlump like connect your changes into a git repo or sync from server a to b

  Sources   Download

MIT

by Carlos Herrera

mysql sync mysqldump