Backing up the SQL database

[John_NJ]

What files do I need to backup to make sure I have a complete backup of the board in case it gets hosed ? I see a file on my server with a .sql extension but that cant be the only file. It is only 35k and my board has 25000 posts.

[Seta Soujiro]

Go into the Admin panel and choose forum maintenance, and download the backup.  The file on the server is not the backup it's a blank database.

[John_NJ]

Ok, I downloaded the backup. Now is the all important question. What if I need to restore the backup ? Where do I upload it? It seems the only place I can do that is in CPANEL.

[Elmacik]

you can do it in cpanel, you can do it in phpmyadmin, you can do it in smf administration panel..
choose one

[Anakin_holland]

And a bit more specific on Cpanel/phpmyadmin: Look here

4^th point

It's about moving a DB to another server, but that's the same if it's a restore after a crash...

Greetz!