Migrating very large account to new server

[Dave Sawyer]

Hi,

We have just taken delivery of a new server with the same hosting company, as the account on our current server has outgrown its needs. The main volume is 500GB and we are using just under 400GB.

I need to move the hosting account to the new server, but realise we do not have enough disk space on the source server to package the account up, so it can be moved. The account includes 7 mysql databases of which the largest is 237GB.

Can anyone point me to a guide as to how I can manually copy the databases over to the new server, without having to generate a mysql dump on the local machine.

Many Thanks

Dave

 

[24x7server]

Hi,

You can try using the WHM Transfer Tool. It will move the Account arch data first and then it will sync the home directory.
Give it a try.

 

[Dave Sawyer]

No, that is no good. Firstly not enough disk space on the source server available to create the packages on and also packaging up databases this size is not best practice. Is there a command to just rsync the mysql databases over, without having to create a dump on the source server, as there is not enough space.

I have manually moved the cpanel hosting account fine. It is just the MySQL DB's that I have the problem with.

 

[Tiberiu]

Best way to migrate a database is to make a dump from mysql and imported to the new server but you dont have enough space. You can try to add a new disk and mount it and export the database on that disk. Thats what i will do anyway.

Now, there are other options to: if you have a db that has only Myisam tables you can recreate it to the new server and just sync the content from /var/lib/,mysql/database from the old server.
If you have Innodb tables you cand sync the database and ibdata on the new server, i've done this but not with such a big database.

Good luck.

 

[dalem]

Use WHM Transfer "skip home dir " option
then use rsync to move the files

 

[Jcats]

You can use mysqldump and import it remotely so it will not consume any space on the local server, example:

On the source server you would run:

# mysqldump dbname| mysql -u someuser -p -hremoteserver.com dbname

Just make sure you whitelist the source and remote server IP's on each server.

You also have to add a user on the remote server to allow the source server, example..

On the remote server:

# mysql -e "grant all privileges on dbname.* to 'someuser'@'123.123.123.123' identified by 'somepassword';"
# mysql -e "grant all privileges on dbname.* to 'someuser'@'sourceserverhostname' identified by 'somepassword';"
# mysql -e "flush privileges;"

So do this step first along with whitelisting IP's as MySQL port 3306 is most likely closed in the firewall.

Then run your mysqldump command on the source server.

Hope this helps!

Also to add, you can use the WHM > Transfer Tool but exclude the databases, and then import them using the above.

 

[cPanelLauren]

mysqldump for this as suggested by @Jcats will be your best solution. If you need to move files without using the transfer tool you'll want to look at rsync. We have documentation on manual migration here: How to Manually Migrate Accounts to cPanel from Unsupported Control Panels - cPanel Knowledge Base - cPanel Documentation though it does assume an unsupported panel (this shouldn't matter it's just a guideline on what files should be moved and the migration process as a whole)