项目作者: nikukyugamer

项目描述 :
Only dump MySQL data and only restore MySQL data
高级语言: Ruby
项目地址: git://github.com/nikukyugamer/honestly-dump-and-restore-mysql.git
创建时间: 2017-12-28T06:43:01Z
项目社区:https://github.com/nikukyugamer/honestly-dump-and-restore-mysql

开源协议:MIT License

下载


Overviews

  • this app enables you to dump MySQL data and restore MySQL data
    • the data is cloned from source_db to target_db
  • this app has only above function

Required

  • install gem
  1. $ gem install mysql2

Perpare

  • overwrite config.yml as your environment
    • the data of source_db is dumped
    • the dumped data is restored to target_db

Execute

  • ok, now you can execute this app
  1. $ ruby app.rb

Result

  • both MySQLs have the same data
  1. source_db (MySQL) ----- clone -----> target_db (MySQL)

Feature

  • without SQL to READ(SELECT) data
    • because of using mysqldump command
  • without SQL to INSERT data
    • because of using dumped data directly

TOO BAD…

  • it takes a long time
    • because of using mysqldump command
    • because of using dumped data directly
  • test is not written

LICENSE

MIT LICENSE