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.

I can t see the databases after migration from Ensim

Discussion in 'General Discussion' started by wisam74us, Oct 26, 2006.

  1. wisam74us

    wisam74us Member

    Joined:
    Mar 12, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Hi
    I have used the new facility in WHM to migrate some accounts from my Ensim old server
    Main >> Transfers >> Copy multiple accounts from another server
    Things look ok so far (files mails accont), But I can t see the databases using Cpanel nor PHPMyadmin,and the sites those need database to run are down now
    Any idea how to fix that

    Main >> Transfers >> Copy an account from another server
    I tried this also but it didn t work at all and I got this error

    "The remote server didn't report a correct md5sum of the archive. Please ensure you selected the correct type of remote server."
     
    #1 wisam74us, Oct 26, 2006
    Last edited: Oct 26, 2006
  2. RickG

    RickG Well-Known Member

    Joined:
    Feb 28, 2005
    Messages:
    238
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    North Carolina
    When you say you "can't see the databases using Cpanel nor PHPMyadmin" are you using the user's cpanel, or logged into WHM as root?

    What are the permissions and ownership in /var/lib/mysql/ ?

    You may want to look at this suggestion Andy made a few weeks ago:
    http://forums.cpanel.net/showpost.php?p=276058&postcount=4
     
  3. wisam74us

    wisam74us Member

    Joined:
    Mar 12, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Sorry I want to say that the databases were not migrated, just the files

    I am logging through root
    I think the transferring option that Cpanel has added in its latest versions still need a lot of work
     
  4. chilihost

    chilihost Well-Known Member

    Joined:
    Mar 1, 2005
    Messages:
    72
    Likes Received:
    0
    Trophy Points:
    6
    I have not found ensim -> cPanel migrations to be reliable. I have found ensim -> Plesk to work relatively well, and plesk -> cPanel to work OK as well. But no auto-migration works perfectly, you always have to check all is there including your databases, email, accounts, etc...
     
  5. ffeingol

    ffeingol Well-Known Member
    PartnerNOC

    Joined:
    Nov 9, 2001
    Messages:
    215
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    wisam74us,

    What version is MySQL on Ensin and what version on cPanel? We've been running into the same issue. Our Ensim boxes are 4.1 but cPanel are 4.0.x (we'll be upgrading shortly). From looking at the conversion script it just tars up the actual databases (not a dump and load) so it's very doubtful that it would work crossing MySQL versions.

    Frank
     
  6. wisam74us

    wisam74us Member

    Joined:
    Mar 12, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    mysql Ver 11.18 Distrib 3.23.58
    mysql Ver 14.7 Distrib 4.1.21

    Yes they are different versions, so you advice to do the database migration manually ??? and I hope I will not have compatibility problems
     
  7. ffeingol

    ffeingol Well-Known Member
    PartnerNOC

    Joined:
    Nov 9, 2001
    Messages:
    215
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Yea, we have to manually convert the databases (and update the clients scripts). Here is the basic procedure that we use:

    - mysqldump on the Ensim box
    - Create the user/db on cPanel
    - Load the backup
    - Search the clients scripts for "localhost" (an indicator that it's a config file for MySQL) and update with the new db user/name/password

    There are no issues dumping a 3.x MySQL db and loading it to 4.0 or 4.1 (or even 5 for that matter).

    Frank
     
  8. wisam74us

    wisam74us Member

    Joined:
    Mar 12, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Does it work if upgrade MYSQL on the Ensim box and then try the migration again through WHM
     
  9. ffeingol

    ffeingol Well-Known Member
    PartnerNOC

    Joined:
    Nov 9, 2001
    Messages:
    215
    Likes Received:
    1
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    We're testing this, but I'm going to have to guess "no".

    Frank
     
  10. wisam74us

    wisam74us Member

    Joined:
    Mar 12, 2006
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Please update me if you get a good results
     
Loading...

Share This Page