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 Database

Discussion in 'General Discussion' started by nidhin_nl, Jul 11, 2006.

  1. nidhin_nl

    nidhin_nl Member

    Joined:
    Jun 19, 2006
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Where do we get the databases backups for restoration
    Will there be database backup in the /backup/cpbackup folder ?
     
  2. WebScHoLaR

    WebScHoLaR Well-Known Member

    Joined:
    Dec 14, 2005
    Messages:
    511
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    Planet Earth
    You have not described that which backup you are referring to.
     
  3. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    You will find MySQL database backups at:

    /backup/cpbackup/daily|weekly|monthly/dirs/_var_lib_mysql_.tar.gz

    The backup process merely copies the entire contents of /var/lib/mysql without taking any special care when doing so, which means that if a file is locked whilst the copying is happening it won't be copied. Basically, this is a better-than-nothing option.

    Dumps of an individual user's MySQL databases will be found in the user's backup archive:

    /backup/cpbackup/daily|weekly|monthly/user.tar.gz/user/mysql/tablename.sql
     
  4. nidhin_nl

    nidhin_nl Member

    Joined:
    Jun 19, 2006
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    How can we restore a database from the backup if one of the database is corrupted ? Please mention the full path of the folders too .
     
  5. mathew_p_a

    mathew_p_a Member

    Joined:
    Apr 8, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    mysql reatore

    Whenever a database become corrupted, you can try using the repair database option in the WHM.

    Just select the db and it will do the repair.

    To repair from the cpanel, go to mysql databases and there is the repair option alongside each of the databases.

    If you wish to have the database restored, the database backup in the daily backup will be at


    /backup/cpbackup/daily/username/mysql/mysqldbname.sql

    untar the backup at /backup/cpbackup/daily/username.tar.gz if you are having backup in zipped format.
     
Loading...

Share This Page