Cannot Restore My database backup

irit

Registered
Aug 18, 2015
4
0
1
Giesen
cPanel Access Level
Root Administrator
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)!.
 

Attachments

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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

Registered
Aug 18, 2015
4
0
1
Giesen
cPanel Access Level
Root Administrator
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
 

Attachments

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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:

Code:
mysqldump database_name > /path/to/database.sql
Thank you.
 

irit

Registered
Aug 18, 2015
4
0
1
Giesen
cPanel Access Level
Root Administrator
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:

Code:
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?
 

Attachments

irit

Registered
Aug 18, 2015
4
0
1
Giesen
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,909
2,229
463
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.