• 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?

#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
 

Brogan

XenForo moderator
Staff member
#2
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
 

Brogan

XenForo moderator
Staff member
#4
Someone far more knowledgeable than me provided that, which is why I use it.

I've been using it for years without issue.