Dreamhost to cPanel -- Databases...

[Gene Steinberg]

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]

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:

mysqldump db_name > db_name.sql

Then when on cpanel server you can recreate databases in cpanel then go to ssh again and run:

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]

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]

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]

Thank you. I appreciate your response and offer of help.

Peace,
Gene

 

[Gene Steinberg]

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