Backing up phpbb3 database

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Post Reply
User avatar
DraconisCombine
Registered User
Posts: 14
Joined: Sun Dec 17, 2006 4:52 pm

Backing up phpbb3 database

Post by 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
Registered User
Posts: 4
Joined: Thu Dec 29, 2005 9:08 pm

Re: Backing up phpbb3 database

Post by 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.
Post Reply