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.

MySQL Restore Backups

Discussion in 'Database Discussions' started by sahostking, Oct 18, 2014.

  1. sahostking

    sahostking Well-Known Member

    Joined:
    May 15, 2012
    Messages:
    299
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Cape Town, South Africa
    cPanel Access Level:
    Root Administrator
    Hi,

    I'm busy with a Disaster recovery Procedure.

    Would like to know if I have rebackup mySQL databases using:
    0 * * 0 /usr/bin/mysqldump --all-databases | gzip > /backup/mysql/alldatabases.sql.gz


    But seeing as we have offline backups, different drive full backup and cPanel backups I'm thinking the above is overkill?

    Is there a way to easily restore ALL mysql databases only using the cpanel backups?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,453
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Restoring a cPanel account backup the proper way will restore the databases on the account as well.
     
Loading...

Share This Page