Submitted by Jhun Vert on December 29, 2012 - 5:08pm
I wrote this post so that I can easily retrieve information that I pulled from several pages of the internet. I have this need to migrate some large MySQL database to another server and I need to do it from the command line of Linux. To make this information at least a little complete, below is the outline of my situation and what I need to do.
The OS of origin and destination servers are both CentOS 5
The control panel of the origin is cPanel and the destination is a custom made control panel
Databases are MySQL
Most websites are Drupal and some are WordPress
My machine where I am accessing my server is Windows