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

#1
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?
 

Brogan

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

RoldanLT

Well-known member
#9
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