Hello Friends,

Following are the steps to move database from ensim server to cpanel server.

Create a file with all the mysql databases from one domain (type in
each full file name based on the files in the

/var/lib/mysql directory). If there is just one domain then you’ll only
have one domain_com_-_xx entry, if there are several,

then just keep adding the databases.

mysqldump -Q –databases domain_com_-_xx domain_com_-_yy domain_com_-_zz -u root -p –add-drop-table > dump.sql

Step 2: Create the priviliges file

mysqldump mysql > mysql.sql -u root -p

cat mysql.sql | grep domain > mysql2.sql

Step 3: Make the Tar of Files

tar -czvf dump.tar.gz dump.sql mysql2.sql

Step 4: Transfer the files

ftp new.cpanelserver

put dump.tar.gz

At cpanel server you need to do the following steps
Login to cpanel server.

step 1:Start in the directory in /home/admin
cd /home/admin

tar -zvxf dump.tar.gz

Step 2: Run the vi editor to do a search/replace on database name

vi dump.sql

:%s/ecclestoned_com_-/ecclestoned/g

Step 3: Run the vi editor to do a search/replace on the permissions to fix
some version issues.

vi mysql2.sql

:%s/ecclestoned\\\\_com\\\\_-\\\\/ecclestoned/

:%s/);/,’Y',’Y');

Step 4: Run mysql hosting to import the databases

mysql mysql -u root -f