Skip to content
This repository has been archived by the owner on Mar 22, 2022. It is now read-only.

nikukyugamer/honestly-dump-and-restore-mysql

Repository files navigation

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
$ 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
$ ruby app.rb

Result

  • both MySQLs have the same data
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

About

Only dump MySQL data and only restore MySQL data

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages