Cannot Restore My database backup

irit

• August 18, 2015 12:31

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

  • August 18, 2015 17:37

  Hello :) Does a database by that name already exist under an account? Is the database name the same as the account username? Thank you.

  0
• 

  irit

  • August 18, 2015 18:27

  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

  0
• 

  cPanelMichael

  • August 18, 2015 19:07

  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.

  0
• 

  irit

  • August 18, 2015 19:24

  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?

  0
• 

  irit

  • August 19, 2015 12:32

  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.

  0
• 

  cPanelMichael

  • August 19, 2015 12:38

  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.

  0

Please sign in to leave a comment.