Problem with MySQL database

raafat1994

Registered
Oct 24, 2016
3
0
1
egypt
cPanel Access Level
Root Administrator
hi
i transfered my websites from server with cpanel to another server with cpanel also
but one of my websites didnt work
- Removed -
after searching about the problem i found out that mysql database which mentioned in website config.php doesn't appear in mysql section in user's cpanel
and same problem in the old server but it work in the old server
- Removed -


i found the database which mentioned in website config.php in this path in the old server /var/lib/mysql
and i tried to transfer it to the new server
but it didnt work
 
Last edited by a moderator:

Eminds

Well-Known Member
Nov 10, 2016
319
34
28
India
cPanel Access Level
Root Administrator
not sure how you transfered the database but you can do so by backing up the database with mysqldump command , transfer it to the new servers and restore it on the new server in /var/lib/mysql

Or try remigrating the complete account from whm transfer tool
 
  • Like
Reactions: raafat1994

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
and i tried to transfer it to the new server
but it didnt work
Hello,

Could you let us know what steps you took to manually transfer the database, and what part of the manual transfer didn't work? You can also browse to "WHM >> Review Transfers and Restores" to see why the database wasn't copied over during the initial transfer attempt.

Thank you.
 
  • Like
Reactions: raafat1994