Backing up phpbb3 database

[DraconisCombine]

When backing up a phpbb3 database, what SQL options should be enabled in phpMyAdmin, and what bearing do they have on the backup?

Thanks.

[spudlet]

do you have ssh access to your box?
I would strongly recommend using mysqldump instead of a php tool:

Code: Select all

mysqldump -u <USERNAME> --password="<PASSWORD" <DBNAME> | gzip > `date +%Y.%m.%d`.forums.sql.gz

That will dump out your database and then gz it up with the date prefixed.
Just run that from the command line.