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.

database can't be connected after sites migration via cpanel copy muliti ...

Discussion in 'Database Discussions' started by linson66, Sep 4, 2011.

  1. linson66

    linson66 Registered

    Joined:
    Sep 4, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    database can't be connected after sites migration via cpanel copy muliti ...

    I found some versions of cpanel have bugs, I am not clear enough, I use cpanel 11.30.* most.

    recently I migrated many sites from one cpanel server to another, after all done. I found most of my websites met database connect errors. then I checked all of those database were moved to the new correctly, I doubted if there were database privileges problems,then I reload mysql privileges,it didn't work at all. and I also checked
    those privileges,seemed all are right,but the websites sill couldn't connect.

    then I loginned WHM,then entered the sub cpanel, I clicked the "Mysql",it listed the database, then the website can work rightly. nothing else I did...it just worked....so strange...

    but that's a problem, usually I have many websites,I can't do as that one by one, any one have good ideas?
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Do both machines run the same MySQL version? Please run the following in root SSH:

    Code:
    mysql_config --version
    Otherwise, are you seeing any errors in the error log for Apache or MySQL when trying to access the site?

    Code:
    tail -fn0 /var/lib/mysql/hostname.err
    tail -fn0 /usr/local/apache/logs/error_log
    Please replace hostname with the full hostname for the machine (you can obtain this using "hostname -f" command).
     
Loading...

Share This Page