Evren Yurtesen - Automated MySQL Mover

Automated MySQL Mover Download

Description:

This script moves all databases of a user from one MySQL server to another MySQL server. Notice that all databases of one user must be in the same MySQL server.

The only thing one should make sure is to run the script with right arguments and make sure that you have enough space in /tmp folder for storing largest of the user databases.

PLEASE USE IT ON YOUR OWN RISK

Supply a user_ db string and target logical server id to start
Must be run with cpanel user in CP!
Make it sure that you supply right arguments otherwise things might go wrong!

Ex. ./mysqlmove.pl mygreatuser_ 24

Notes:
1- Your MySQL must be accessible by root from CP
2- This script WILL NOT clean the old DB. Please do it manually
3- There can be some other things I didnt think about. Please inform if you find any problems
4- Use it on your own risk!

!!! PLEASE RUN AS cpanel USER !!!

# v0.0.1    - Initial version.
# v0.0.2    - Bugfix, problem with database import fixed (by bcarlos)
#        - Bugfix problem with mysql5 database reload (by bcarlos)

Submitted On: