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.

Restoring a Database backup while using all of the number of databases allowed

Discussion in 'General Discussion' started by r_honey, Sep 20, 2009.

  1. r_honey

    r_honey Member

    Joined:
    Aug 1, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    My Hosting provider allows me 5 MySql DBs on my Hosting Account. Till last week, I had used 4 of these. My backups & restores of the DBs from the CPanel went smoothly. This week, I added the final 5th DB allowed in my account.

    Today, I was trying to restore one of the DBs from the CPanel. I got this message:
    "
    Restoring Database
    Sorry you have exceeded the maximum maximum allowed databases".

    After that, I got those Sql statements that are executed for restoring the database.

    Now, I have 2 questions here:
    1) I have NOT exceeded the maximum number of databases. I am allowed 5, and I have 5 of them. I am just trying to restore one of them without adding a new one. So, why I am getting this message.

    2) Even after getting this message, the database was restored successfully. I deleted all tables in the DB, and restored the backup. I got this message, but still the tables and the data was restored successfully.
    So, can I safely ignore this message as I am NOT exceeding my limit, or does this message means there might be some problem and my database might not have been restored fully??
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    38
    May I know which cPanel/WHM stable version are you using? Upgrade to latest stable version if you are using old version.
     
  3. r_honey

    r_honey Member

    Joined:
    Aug 1, 2009
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    My cPanel version

    My cPanel show me the following:

    cPanel Version 11.24.5-RELEASE
    cPanel Build 38506
     
  4. Spiral

    Spiral BANNED

    Joined:
    Jun 24, 2005
    Messages:
    2,023
    Likes Received:
    7
    Trophy Points:
    0
    Side FYI .... It probably really shouldn't count but there is a "hidden" test database that you don't normally see listed. Consider that when you are counting your databases.

    Beyond that, 5 databases is a bit on the restrictive side. I would see about getting more from your hosting provider or find a new host.
     
  5. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    Are you attempt to restore into an empty database or a database that already has data in it?
     
Loading...

Share This Page