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.

SQL backups in full website backup using cpanel

Discussion in 'General Discussion' started by equinoxaw, Mar 24, 2011.

  1. equinoxaw

    equinoxaw Registered

    Joined:
    Mar 24, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    I recently used Cpanel to back up our entire website. The file was generated and downloaded locally to our home pc. Now we need to restore one of the databases which was supposed to be backed up during the full website backup, but looking in the compressed file I have yet to find any of the SQL backups; so my question is where the heck are they??? I know I can decompress the whole thing and search the folder but the backup is around 120 Gig and decompressing entirely will slow our local machine and max the hard drive; if we could locate that SQL backup and just extract that and then restore it , it would save us a lot of trouble and time. Any feedback and information anyone might provide will be extremely helpful. Thank for your time everyone.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    For the full cPanel backups, the MySQL database sql files are contained in the mysql folder named username_dbname.sql for each database where username is the cPanel username and dbname is the database name. The path is basically the following when extracted:

    backup-M.DD.YY_HH-MM-SS_username/mysql/username_dbname.sql
     
  3. equinoxaw

    equinoxaw Registered

    Joined:
    Mar 24, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Thank you so much for your quick reply. We highly appreciate it.

    P.S.. We located the file and extracting now. Thanks again :)
     
Loading...

Share This Page