Migrate a MySQL database from one host to another host.
A vagrant file is provided that will allow you to build an Ubuntu Wiley 64 box which you can use to run db-migrate.
-
cd path/to/db-migrate/devel -
vagrant up devel
This will build the development vagrant box -
Go to the development directory:
cd /development -
chmod +x build.sh && ./build.sh
This will "build" the Python script to an executable file -
To use dbmigrate:
dbmigrate --src 127.0.0.1 username database --dest 127.0.0.1 username
The following information must be provided and in this order:- Source DB Hostname/IP (i.e. 127.0.0.1)
- Source DB Username
- Source DB Database
- Destination DB Hostname
- Destination DB Username (must have database creat privileges)