The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cannot Restore My database backup

Discussion in 'Database Discussions' started by irit, Aug 18, 2015.

  1. irit

    irit Registered

    Joined:
    Aug 18, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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)!.
     

    Attached Files:

  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. irit

    irit Registered

    Joined:
    Aug 18, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Giesen
    cPanel Access Level:
    Root Administrator
    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
     

    Attached Files:

  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    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.
     
  5. irit

    irit Registered

    Joined:
    Aug 18, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Giesen
    cPanel Access Level:
    Root Administrator
    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?
     

    Attached Files:

  6. irit

    irit Registered

    Joined:
    Aug 18, 2015
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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.
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page