Cannot Restore My database backup

[irit]

Hi, I have just moving to new server. I have backup my database from the old server. when I try to restore my database in the new serve it says You do not have access to that database (myDatabaseName)!.

 

[cPanelMichael]

Hello

Does a database by that name already exist under an account? Is the database name the same as the account username?

Thank you.

 

[irit]

Hello

Does a database by that name already exist under an account? Is the database name the same as the account username?

Thank you.

Thank you for replying. No there is no same database name that already exist.
Actually when i extracted the sql.gz file and open with notepad it contain the same message. You do have access to that database name

 

[cPanelMichael]

Could you verify if there are any error messages when manually backing up the database on the source server? Try doing so via the following command:

mysqldump database_name > /path/to/database.sql

Thank you.

 

[irit]

Could you verify if there are any error messages when manually backing up the database on the source server? Try doing so via the following command:

mysqldump database_name > /path/to/database.sql

Thank you.

Actually the problem is I don't have any acces anymore to my old server
I only the backup file of the old server. But unfortunately I cannot restore to my new server.

By the way, in my backup folder contain 3 folders, MySQL, alias and filter. Is it possible that I have to merge this 3 folder before restore to cpanel?

 

[irit]

Hi, I have *.sql.gz file. When I open it, it contained "You do not have access to that database(name_of_mydatabase )!".

Is my *.sql.gz file corrupt? or Should I open the the file with another way?

Thank you.

 

[cPanelMichael]

You could try browsing those folders to see if additional backups are available, but you do not have a valid MySQL database backup based on your earlier response. It looks like the backup did not generate successfully.

Thank you.