Mysql Database

[nidhin_nl]

Where do we get the databases backups for restoration
Will there be database backup in the /backup/cpbackup folder ?

 

[WebScHoLaR]

You have not described that which backup you are referring to.

 

[webignition]

Where do we get the databases backups for restoration
Will there be database backup in the /backup/cpbackup folder ?

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

 

[nidhin_nl]

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 .

 

[mathew_p_a]

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.