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

XF 1.2 Backing up the database questions.

When backing up the database would I want to select "Complete Inserts," and/or "Extended Inserts?"

These are the options I currently use to backup the database. Do they all look correct?


XenForo moderator
Staff member
When doing it on localhost via phpMyAdmin I just leave it at the defaults.
When doing it via SSH I use this:
mysqldump -u<user> -p<password> --single-transaction --skip-lock-tables <db-name> > /path/to/backup/<db-name>_$(date +%d.%m.%y).sql


Well-known member
I mean XF 1.3.0 beta. Are they working fine?
How are you backing up? daily to the server and ftp it somewhere else?
Yes I'm using XF 1.3.0
My Database size is almost 2GB (1.8GB to be specific)
Yes it works fine.
I'm backing up it manually, you may create a cron to backup your database using another server, with this: http://sypex.net/en/products/dumper/docs/
in unix systems:

/usr/local/bin/php /absolute_path_to_dumper/index.php -j=my_job