1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 CLi backup ok?

Discussion in 'XenForo Questions and Support' started by assemblergames, Jun 2, 2015.

  1. I'm currently backing up via CLI using:

    mysqldump --opt -Q -u USERNAME -p DBNAME > thatfile.sql

    Is there a reason you prefer to not use method? Your recommended is:

    mysqldump --opt -u USERNAME -p DBNAME
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    I prefer to use this for dumping:
    Code:
    mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql
     
    maszd and assemblergames like this.
  3. Can you please elaborate on your specific switch choice?

    Also, do you recommend mysqlcheck -r ?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Someone far more knowledgeable than me provided that, which is why I use it.

    I've been using it for years without issue.
     
    assemblergames likes this.
  5. Ok thanks, and I assume essential to close board before backup?

    Database is over 1GB, is there any DB size issue?
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    It's not essential but it's probably a good idea if it's a very busy site.
     
    assemblergames likes this.

Share This Page