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.

Backup a very large database file

Discussion in 'Data Protection' started by Todi Adiyatmo, Jun 25, 2015.

  1. Todi Adiyatmo

    Todi Adiyatmo Registered

    Joined:
    Jun 25, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Yogyakarta
    cPanel Access Level:
    Root Administrator
    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"

    http://dba.stackexchange.com/questi...on-a-live-system-with-active-reads-and-writes

    How to make all backup in my cpanel is using --single-transaction params ?

    Cheers.
    Todi
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,734
    Likes Received:
    661
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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:

    Code:
    mysqldump --single-transaction database_name > /path/to/backup_db.sql
    Thank you.
     
Loading...

Share This Page