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

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


XenForo moderator
Staff member
I prefer to use this for dumping:
mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql


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.