Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    Mar 2011
    Posts
    2

    Default SQL backups in full website backup using cpanel

    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. #2
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    6,305
    cPanel/Enkompass Access Level

    Root Administrator

    Default Re: SQL backups in full website backup using cpanel

    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
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Forums Technical Analyst, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  3. #3
    Registered User
    Join Date
    Mar 2011
    Posts
    2

    Default Re: SQL backups in full website backup using cpanel

    Quote Originally Posted by cPanelTristan View Post
    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
    Thank you so much for your quick reply. We highly appreciate it.

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

Similar Threads & Tags
Similar threads

  1. Replies: 12
    Last Post: 12-21-2010, 03:47 PM
  2. Backup Drive is full - need to delete old backups
    By constantine in forum Data Protection
    Replies: 2
    Last Post: 03-04-2009, 02:10 PM
  3. How to disable Full cPanel Backups
    By johnbw in forum Data Protection
    Replies: 3
    Last Post: 07-22-2008, 09:25 AM
  4. Running full cPanel backups
    By DBJoshua in forum cPanel and WHM Discussions
    Replies: 1
    Last Post: 06-12-2007, 03:03 AM
  5. New Backup Drive Installed would like to force full backups
    By soupa in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 07-02-2003, 09:05 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube