[mXm] kotaco Posted August 12, 2013 Report Share Posted August 12, 2013 just thought I'd share: http://imageshack.us/a/img407/108/huek.png We're doing monthly SQL backups and biyearly full site backups stored on an external harddrive. No more disastrous forum crashes of 2006 for this clan :P Quote Link to comment Share on other sites More sharing options...
[mXm] BalzOnYer4Head Posted August 12, 2013 Report Share Posted August 12, 2013 That is good good news indeed. Quote Link to comment Share on other sites More sharing options...
[mXm] andy19 Posted August 12, 2013 Report Share Posted August 12, 2013 Ah backups, saving programmers' asses since 1990. Quote Link to comment Share on other sites More sharing options...
Induced_Horizon Posted August 13, 2013 Report Share Posted August 13, 2013 Just a heads up ... Sometimes Backups don't totally work out as planned .... I had a site fail once before and I had some backups but when I tried to use them , I kept getting corrupt file errors and still lost everything .. but on a plus note I have also been saved by backups as well . so don't get me wrong , you are doing a good thing . just want to make a few more suggestions . 1# SQL Export your database into a Document . That way you can do a direct SQL Query to restore your Database . Mainly because sometimes when a site crashes it might not let you in to your Admin Panel to be able to use a generated backup . 2# Also want to suggest that you Duplicate your database now and then .(you can always Delete databases if you get to many of them ) that way if there is a crash you can hurry up and connect to the 2nd database to keep things operational . This option would only be for Emergencies . Because if you change Database names none of your backups will work , But you will still have a working database . Quote Link to comment Share on other sites More sharing options...
[mXm] andy19 Posted August 13, 2013 Report Share Posted August 13, 2013 I_H speaks the truth. Although I think part of CPanel's export process is building a pure SQL query backup of the database. It's been a while since I've used their backup utility though. It is a good idea to duplicate the database on the same server though, for that exact reason of quick turnaround from corrupt to running. Even if you do it once a week or so, and just keep 2-3 backup databases on the server, while keeping all the backup zip files somewhere on your local filesystem. Quote Link to comment Share on other sites More sharing options...
[mXm] kotaco Posted August 13, 2013 Author Report Share Posted August 13, 2013 The files I backup are zipped .sql files. So they can be restored through import or direct query. You can also use the notepad "find and replace" function to update database prefixes and names should they be changed after a backup is made fairly easily. Our service also take nightly server backups of the full site, home directory, public_html, and all the databases that are able to be restored if needed should all of mine fail. Quote Link to comment Share on other sites More sharing options...
[mXm] andy19 Posted August 13, 2013 Report Share Posted August 13, 2013 Sounds like we're well covered. Good stuff. Quote Link to comment Share on other sites More sharing options...
Induced_Horizon Posted August 13, 2013 Report Share Posted August 13, 2013 That is a plus that all that is set up for you .. I still have to do it all the old school way on all my sites was just trying to give heads up ... but sounds like it is all under control Quote Link to comment Share on other sites More sharing options...
[mXm] andy19 Posted August 13, 2013 Report Share Posted August 13, 2013 If the E-Bricks site is ~17MB of pure SQL, looks like it's doing really well! Quote Link to comment Share on other sites More sharing options...
[mXm] srans Posted August 14, 2013 Report Share Posted August 14, 2013 I kinda miss the days of having to re-register every time i wanted to post on the forum lol Quote Link to comment Share on other sites More sharing options...
[mXm] BalzOnYer4Head Posted August 14, 2013 Report Share Posted August 14, 2013 :lol: it was a dedication test... NAILED IT Quote Link to comment Share on other sites More sharing options...
[mXm] kotaco Posted August 15, 2013 Author Report Share Posted August 15, 2013 [quote name='Induced_Horizon' timestamp='1376434540' post='3141'] That is a plus that all that is set up for you .. I still have to do it all the old school way on all my sites was just trying to give heads up ... but sounds like it is all under control No problem, I've been taking care of this and a few other sites since 2004, so I've learned along the way, sometimes the hard way. So I have us pretty well covered now. [quote name='srans' timestamp='1376445697' post='3144'] I kinda miss the days of having to re-register every time i wanted to post on the forum lol And you came on board in 2008, so you only got a portion of the full experience, didn't even get to experience our forum software shifts. :P [quote name='andy19' timestamp='1376437236' post='3142'] If the E-Bricks site is ~17MB of pure SQL, looks like it's doing really well! Some of that is due to modifcations adding in table rows to the database, but it is doing well. 400+ members and about 18,000 posts. Quote Link to comment Share on other sites More sharing options...
Self-proclaimed experts in tactical gaming since 2004
Self-proclaimed experts in tactical gaming since 2004
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.