The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Dreamhost to cPanel -- Databases...

Discussion in 'Migrate to cPanel' started by Gene Steinberg, Dec 18, 2012.

  1. Gene Steinberg

    Gene Steinberg Well-Known Member

    Joined:
    May 26, 2007
    Messages:
    157
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
  2. bbrink68

    bbrink68 Active Member

    Joined:
    Nov 27, 2012
    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    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
     
  3. Gene Steinberg

    Gene Steinberg Well-Known Member

    Joined:
    May 26, 2007
    Messages:
    157
    Likes Received:
    1
    Trophy Points:
    18
    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.
     
  4. quanin

    quanin Well-Known Member

    Joined:
    Aug 18, 2011
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  5. Gene Steinberg

    Gene Steinberg Well-Known Member

    Joined:
    May 26, 2007
    Messages:
    157
    Likes Received:
    1
    Trophy Points:
    18
    Thank you. I appreciate your response and offer of help.

    Peace,
    Gene
     
  6. Gene Steinberg

    Gene Steinberg Well-Known Member

    Joined:
    May 26, 2007
    Messages:
    157
    Likes Received:
    1
    Trophy Points:
    18
    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
     
Loading...

Share This Page