I just want to clarify that I am doing this right before I continue.
I am intending to do weekly backups of my forum database, and so I have logged into the PHPMYADMIN area, clicked on the database, and I’ve seen the list of 30 or so tables.
If I want to backup the database, do I just:
- Select all tables
- Leave it as SQL
- Leave all of the other settings (tick in Add AUTO_INCREMENT value, and enclose table and field names with backquotes, and under data, complete inserts, extended inserts, 50000 maximal length of query, use hexadecimal for binary fields, export type INSERT)
- Save as file, and type in a name (and gzipped)
If this is the case, then where will the file be saved to, and is this the correct way of backing up your forum database or is there an easier/better way?