Backup a very large database file

Todi Adiyatmo

• June 25, 2015 01:40

Hi All, I'am running CPanel latest version and have a wordpress multisite. The problem i'am facing is when the backup run, the database would lock and the site is not accesible. I found a solution for manual backup using "--single-transaction"

• 

  cPanelMichael

  • July 08, 2015 17:36

  Hello :) What method are you using to generate the backup? You can disable MySQL backups and backup the database manually with the command referenced in the URL you provided:
  mysqldump --single-transaction database_name > /path/to/backup_db.sql
  Thank you.

  0

Please sign in to leave a comment.