Cpanel transfer completed but cannot find database

[farooq]

Hi,

One of the accounts which was transferred via cpanel transfer tool does not show databases in the database section in cpanel(New Server). It says that the databases already exist as when i try to create these manually. I can see the DBusers and password but cannot see the databases. DO i need to delete everything and do the transfer again? I will appreciate help.

Thanks.

Here is the transfer log from cpanel transfer :

Mysql
Preparing MySQL restore …

Restoring MySQL databases
Restoring the database “xxxxx_xxxpi@465hh78” as “xxxxDBapi@465hh78” …
The system has created a new database named “movietv_mtDBapi@465hh78”.
Granting “xxxxx” access to “movietv_mtDBapi@465hh78” with temporary password …
Spawning restoration subprocess for “xxxxx@465hh78” …
Connecting to MySQL server as “xxxx” in order to restore “moxxxxpi@465hh78” …
Releasing objects in preparation for database restore for “moxxxxpi@465hh78” …
Cleaning up in preparation for database restore for “movxxxi@465hh78” …
Disabling InnoDB strict mode for database restore for “movixxxapi@465hh78” …
Restoring database data for “mxxxxpi@465hh78” …
The database restoration subprocess for “mxxxx@465hh78” is running …
HTTP/1.1 403 Forbidden Access denied Content-Length: 15 Content-Type: text/plain; charset="utf-8" Connection: close Date: Sat, 31 Dec 2022 02:15:40 GMT Access denied
The database restoration subprocess for “mxxxxxx8” has ended.
The system has restored the contents of the database “mxxxxxi@465hh78”.
Retrying …
Restoring the database “mxxxxxBapi@465hh78” as “mxxxxxi@465hh78” …
The system will rename the unmanaged database “moxxxxpi@465hh78” to “moxxxxBapi@465hh782”.
The system has created a new database named “moxxxxxBapi@465hh78”.
Granting “xxxxxx” access to “mxxxxxhh78” with temporary password …
Spawning restoration subprocess for “mxxxxpi@465hh78” …
Connecting to MySQL server as “mxxxxx” in order to restore “mxxxxxi@465hh78” …
Releasing objects in preparation for database restore for “moxxxxi@465hh78” …
Cleaning up in preparation for database restore for “moxxxapi@465hh78” …
Disabling InnoDB strict mode for database restore for “mxxxxi@465hh78” …
Restoring database data for “mxxxxapi@465hh78” …
The database restoration subprocess for “moxxxxpi@465hh78” is running …
HTTP/1.1 403 Forbidden Access denied Content-Type: text/plain; charset="utf-8" Content-Length: 15 Date: Sat, 31 Dec 2022 02:15:40 GMT Connection: close Access denied
The database restoration subprocess for “mxxxxapi@465hh78” has ended.
The system has restored the contents of the database “moxxxpi@465hh78”.
The WebSocket handshake failed because of an error: Forbidden Access denied
Restoring the database “moxxxxedx@35#46” as “mxxxdx@35#46” …
The system has created a new database named “movietv_Embedx@35#46”.
Granting “mxxxx” access to “mxxxxxdx@35#46” with temporary password …
Spawning restoration subprocess for “mxxxxx@35#46” …
Connecting to MySQL server as “mxxxx” in order to restore “mxxxxdx@35#46” …
Releasing objects in preparation for database restore for “mxxxdx@35#46” …
Cleaning up in preparation for database restore for “moxxxedx@35#46” …
Disabling InnoDB strict mode for database restore for “mxxxxxedx@35#46” …
Restoring database data for “mxxxxdx@35#46” …
The database restoration subprocess for “moxxxxdx@35#46” is running …
HTTP/1.1 403 Forbidden Access denied Date: Sat, 31 Dec 2022 02:15:40 GMT Connection: close Content-Length: 15 Content-Type: text/plain; charset="utf-8" Access denied
The database restoration subprocess for “mxxxxx@35#46” has ended.
The system has restored the contents of the database “moxxxxdx@35#46”.
Retrying …
Restoring the database “moxxxxdx@35#46” as “movxxxxx@35#46” …
The system will rename the unmanaged database “movxxxdx@35#46” to “mxxxxdx@35#462”.
The system has created a new database named “moxxxxx@35#46”.
Granting “movietv” access to “movixxxdx@35#46” with temporary password …
Spawning restoration subprocess for “moxxxxx@35#46” …
Connecting to MySQL server as “mxxxx” in order to restore “movxxxxdx@35#46” …
Releasing objects in preparation for database restore for “movixxxdx@35#46” …
Cleaning up in preparation for database restore for “moxxxdx@35#46” …
Disabling InnoDB strict mode for database restore for “moxxxxedx@35#46” …
Restoring database data for “movxxxx@35#46” …
The database restoration subprocess for “moxxxx5#46” is running …
HTTP/1.1 403 Forbidden Access denied Content-Length: 15 Content-Type: text/plain; charset="utf-8" Connection: close Date: Sat, 31 Dec 2022 02:15:40 GMT Access denied
The database restoration subprocess for “mxxxx@35#46” has ended.
The system has restored the contents of the database “moxxxxx@35#46”.
The WebSocket handshake failed because of an error: Forbidden Access denied
Restoring the database “movixxx6fjh” as “mxxx56fjh” …
The system has created a new database named “mxxx6fjh”.
Granting “moxxxv” access to “movxxx756fjh” with temporary password …
Spawning restoration subprocess for “mxxx56fjh” …
Connecting to MySQL server as “mxxxx” in order to restore “xxx56fjh” …
Releasing objects in preparation for database restore for “xxxy756fjh” …
Cleaning up in preparation for database restore for “xxx756fjh” …
Disabling InnoDB strict mode for database restore for “mxxxky756fjh” …
Restoring database data for “movietv_linky756fjh” …
The database restoration subprocess for “movietv_linky756fjh” is running …
HTTP/1.1 403 Forbidden Access denied Connection: close Date: Sat, 31 Dec 2022 02:15:40 GMT Content-Length: 15 Content-Type: text/plain; charset="utf-8" Access denied
The database restoration subprocess for “movietv_linky756fjh” has ended.
The system has restored the contents of the database “movietv_linky756fjh”.
Retrying …
Restoring the database “movietv_linky756fjh” as “movietv_linky756fjh” …
The system will rename the unmanaged database “movietv_linky756fjh” to “movietv_linky756fjh2”.
The system has created a new database named “movietv_linky756fjh”.
Granting “movietv” access to “movietv_linky756fjh” with temporary password …
Spawning restoration subprocess for “movietv_linky756fjh” …
Connecting to MySQL server as “movietv” in order to restore “movietv_linky756fjh” …
Releasing objects in preparation for database restore for “movietv_linky756fjh” …
Cleaning up in preparation for database restore for “movietv_linky756fjh” …
Disabling InnoDB strict mode for database restore for “movietv_linky756fjh” …
Restoring database data for “movietv_linky756fjh” …
The database restoration subprocess for “movietv_linky756fjh” is running …
HTTP/1.1 403 Forbidden Access denied Date: Sat, 31 Dec 2022 02:15:40 GMT Connection: close Content-Type: text/plain; charset="utf-8" Content-Length: 15 Access denied
The database restoration subprocess for “movietv_linky756fjh” has ended.
The system has restored the contents of the database “movietv_linky756fjh”.
The WebSocket handshake failed because of an error: Forbidden Access denied
Restoring MySQL database mappings

Restoring MySQL privileges

Restoring MySQL grants

Restoring MySQL access hosts

Storing MySQL Grants

Mysql

 

[cPRex]

Hey there! It's odd that there are 403 errors in the restore log. Since that happened, it might be best to remove the account and try the transfer again, as you mentioned.

You could also try running a "mysqldump" on the existing database to see if there is an issue on the Source server causing a problem with the restore. Here is an example command to see if that works:

mysqldump database_name > output.sql

If that doesn't give errors, it would be best to try the transfer again.