just want to know how to restore a database/posts (the entire forum) on my SMF 1.1.7 in case something happens or the forum get hacked :)
do i just upload the backup database to my server and ad the database settings @ admin board under the server settings? do i need to do anything else?
Different people have differing methods. I simply go to my cpanel and do a "Full home directory" backup and backup the database.
You can restore, from there, just as easily.
Odd SMF thing, is that you can backup the database from admin, but not restore.
Quote from: Kat on January 10, 2009, 05:10:25 AM
Different people have differing methods. I simply go to my cpanel and do a "Full home directory" backup and backup the database.
You can restore, from there, just as easily.
Odd SMF thing, is that you can backup the database from admin, but not restore.
what if i only takes backup of the database ONLY, since my blog is in the same home dir it will take the blogs backup also if i do a full home directory backup.
will that still work to only backup the database?
As long as your site doesn't get hacked and the files changed.
You could backup the files, via ftp. Just download the whole forum directory to your drive.
That way, you only need to re-backup, if you add any mods, or change any files.
You should backup the files as well. If you don't you won't have a backup of attachments.
bigdump and phpmyadmin will restore just the database .sql files though.
See: What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)