Dreamhost to cPanel -- Databases...

Gene Steinberg

Well-Known Member
May 26, 2007
157
1
168
Is there a simple script that would allow me to move these over?

Standard domain files should appear to be easy to transfer.

But it seems that DH is managing database naming/location differently, right?

And I assume none of cPanel's transfer scripts can be modified for this?

Just my eternal quest to make my life simpler.
 

bbrink68

Active Member
Nov 27, 2012
26
0
1
cPanel Access Level
DataCenter Provider
Do you have ssh access at DH? You could ssh in as root then drop to a MySQL prompt by typing 'mysql' then dump your databases into .sql files using:

Code:
mysqldump db_name > db_name.sql
Then when on cpanel server you can recreate databases in cpanel then go to ssh again and run:

Code:
mysql db_name < db_name.sql
No easy script that I know of but if your just worried about databases this should work
 

Gene Steinberg

Well-Known Member
May 26, 2007
157
1
168
OK, when it makes the dump, does it put that in the same directory as the original?

And when you upload the dump on the new server, do you put it in the same folder as other databases?

Stupid questions, I know. Just want clarification.
 

quanin

Well-Known Member
Aug 18, 2011
125
7
68
cPanel Access Level
Root Administrator
I can write you up a script for doing something similar if you'd like. Having performed this migration once or twice on my end, I know it can be a tiny bit of a pain. Get in touch with me, and I'll see what I can do.
 

Gene Steinberg

Well-Known Member
May 26, 2007
157
1
168
And I would like to add that James spent a fair amount of time working with me to get my DH databases imported, and they came through perfectly. It made what could have been an irritating migration process relative perfection.

Aside from the usual minor adjustments to configurations and hard-coded file paths and permissions, I got everything working in fairly short order.

Peace,
Gene