traderob Posted September 23, 2013 Share Posted September 23, 2013 hi if i do the sql backup( which i do religiously) what does it save. i just use the standard settings as below. if i get hacked will i be able to restore all data including posts with formatting etc? member lists? in other words it will take me back to the day of my backup without any loss of data? the option for skiing non-essential data leave as yes. is that ok? MySQL 5.1.56-log Backup Simple Backup Add 'CREATE TABLE' statements? YesNo Skip non essential data? YesNo Will not produce insert rows for sessions, admin_sessions, captcha. GZIP Content? YesNo Link to comment Share on other sites More sharing options...
AndyF Posted September 23, 2013 Share Posted September 23, 2013 I tend to do a database (sql) backup then about every third one a filesystem backup. Bear in mind uploads ie profile photos / post attachments / gallery images if you have gallery / downloads if you have downloads are in the filesystem and will not be backed up with a database backup. What your sql backup is, is the forum / posts / topics / members / personal messages etc. Old article I wrote but still reasonably relevant > http://community.invisionpower.com/resources/articles.html/_/server-resource-management/taking-a-manual-backup-using-cpanel-r240 Link to comment Share on other sites More sharing options...
traderob Posted September 23, 2013 Author Share Posted September 23, 2013 thanks, very helpful! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.