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

[linson66]

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]

Do both machines run the same MySQL version? Please run the following in root SSH:

mysql_config --version

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

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).