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

linson66

Registered
Sep 4, 2011
1
0
51
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?
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
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).