Make backup only for databases

Abdelmks

• March 21, 2017 12:27

Hello I have tested backups for databases only, and I find it on : /home/backup/[date_of_your_backup]/system/dirs/_var_lib_mysql_.tar.gz I have those questions .. how to use those backups after ? because they are with an incomprehensible extension. can I have backups separately, one file .sql for each user ? Thank you

• 

  Eminds

  • March 22, 2017 02:11

  .tar.gz files are actually easy file to restore when there is a situation where you have to restore complete account. You can use the Restore account feature in WHM and restore the account easily using .tar.gz file provided its a full back up file. If you just want to restore the database then you have untar the tar.gz file using command tar -zxvf file name and then you can move the mysql DBs to the /var/lib/mysql making sure that the permissions are correct. another way is to dump the mysql databases on the source server using comand mysqldump database_name > database_name.sql move the file backup file to source server using FTP or rsync and then restore the database using command mysql database_name < database_name.sql

  0
• 

  Abdelmks

  • March 23, 2017 10:30

  Thank you Mr @Eminds

  0
• 

  cPanelMichael

  • March 23, 2017 16:06

  Hello, I'm happy to see the answer you received was helpful. I'm marking this thread as solved. Thanks!

  0

Please sign in to leave a comment.