XF 1.2 Backing up the database questions.

[LurkerLou]

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?

 

[ForestForTrees]

Dunno, but this worked well for me:
http://xenforo.com/community/resources/how-to-backup-and-restore-your-forum-linux-windows.359/

 

[Paul B]

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

 

[AndyB]

I suggest you don't use phpMyAdmin to backup your server. Use mysqldump as it's the only reliable method IMHO.

 

[rdn]

Sypex is the best

 

[Andy.N]

Sypex is the best

which version are you using? Are they working with 1.3.0?

 

[rdn]

which version are you using? Are they working with 1.3.0?

Just using the recent version v2.0.11, I don't have any idea about 1.3.0

 

[Andy.N]

Just using the recent version v2.0.11, I don't have any idea about 1.3.0

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?

 

[rdn]

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