SMF Support > SMF 2.0.x Support

Need Help Recovering from Corrupted Files

(1/1)

mistermike:
Hello:

I need to know how to recover text postings from a backup.  I am not familiar with any of this.  Our forum had some files deleted.  My IT guy downloaded the backups including the MYSQL database.  Is there any way to recover the posts?  We don't need to reinstall the forum I just want some of the posts.

I don't even know if this is the right board for this kind of thing.

Thanks,

Michael

tinoest:
You can import the SQL file into a new database via phpMyAdmin

Or if you just want the posts you can scan the sql ( database backup ) and just extract them via a text editor.

MrPhil:
If only files were deleted, all the posts are still there. They're stored in the database, not the files. If posts were deleted, you would have to recover them from a backup. If all posts were deleted or the database was corrupted (or you don't mind resetting the whole database to an earlier time), you would simply restore the database from a backup (overwriting the current incomplete data). If only some posts need to be restored, while keeping later posts, that could be a very laborious manual process. If there aren't a huge number of posts to deal with, it might be easiest to cut and paste them from the .sql backup file into SMF as new posts. The dates will be wrong and thus the posts out of sequence, but you'll have to give more details of what happened. Note that the built-in SMF admin database backup is useless. Only back up with phpMyAdmin "export".

If only SMF files are missing or corrupted, you can just overwrite them with copies from a site backup. If you have to go back to a fresh copy of files (from an install package), you may end up with inconsistently installed mods. In that case, you might be best off using a Large Update to refresh all your SMF files, and re-install your mods. That would be a good opportunity to come up to the current (2.0.2) version if you aren't already there.

Navigation

[0] Message Index