Thursday, October 13, 2011 :: Q...
I keep backups of everything. Let me tell you about some of my procedures.
When I make changes to WiredPages- I update the page[s] then copy everything from the current master WiredPages disc to a new one and replace the new files. What is on the WiredPages disc? All of the HTML pages associated with the service, including the Business Directory’s eight pages, the sixteen pages [i.e., home, Business & Markets, Style & Events], that make up the main WiredPages site. Any graphics I create or use with new interfaces are also kept on the intermediate master disc for WiredPages. Note my use of “intermediate master disc”.
I also keep– all of the Java class files and Applets, that I develop which are integrated on WiredPages as interfaces [e.g., itunes, indeed job search, etc]. That said– the disc that is recreated about once or twice a month because of updates is not really the master. The master disc- is actually at the bottom of my book bag and is only updated once a year. That is why the master disc I keep handy is really only the intermediate disc. What is the difference?
Pages I rarely change like the 5 or 6 other pages that are used on WiredPages as popups [e.g. Site Conventions, Abbreviations for Postal Codes, Standards Table, etc.] are not on the intermediate master disc I update frequently. Why? I never update them. Where are they? On the main master discs at the bottom of my book bag.
The master discs at the bottom of the book bag actually contains all of the graphics files, font experiments, and a master set of html pages — the whole site [minus databases– and the new remix blog]. The whole site? That includes the main site area and catalog of qisoftware.com- not just WiredPages. I keep two copies of the master discs at the bottom of my book bag. One set for qisoftware.com and another for hosting-q.com.
I keep a handy [not at the bottom of my book bag] current copy and the last copy before the current for all pages on both [qisoftware.com and hosting-q.com] ready to be changed if I need to. These are the intermediate copies– and actually if I lost them well into the year– I would be very upset in that I only update the real masters about once a year– around January first.
Nothing on either of my sites is the master copy. For example, every single blog entry I post– I keep a local master text file for. I also keep all of the graphics. I also back these files up to an external hard-drive I keep in my book bag. If I make a change to the post– i make the change to the master text file– then cut and paste to either WordPress, Thingamablog, Movable Type or the Blogger user interface. The master copy is always in my possession. I even keep text file backups of the qisoftware-support blog I maintained on blogger servers– along with the bloggercalendar.blogspot.com blog.
What about databases I use? Most of the databases I use are created by the WordPress, PHPBB forum software or Movable Type platforms I use and are backed up when I create full backups of my sites.
I have created three custom databases for use with WiredPages– which I maintain on the hosting-q.com domain. The Zip Code database, celebrity birthdays, and daily horoscopes. Currently, only the Horoscopes database changes daily. That said- I have a master copy locally of the Zip Codes, birthdays were inserted over the first year I installed it which was June 6, 2010 and are no longer being updated unless I run a new program or tweak it manually [like I did this morning– and the reason for this post]. The daily horoscopes are only good for one day and the program deletes all prior day records when the interface is requested the first time each day.
The pouch shown in the following photo only contains site backups for the last two or three years:
Dollar Store Pouch for Backup Discs
I recently moved these backup discs to the new pouch because the one it was in– was too full and also where I keep all my intermediate master discs [WiredPages, Qisoftware main, software source files, etc.]. Here is the contents of the new backup disc pouch:
Last 3 years of Site Backup Discs
The old pouch is very important to me. In the case of the master software files– the hard -drive on my Macbook is actually the master– but I like keeping masters in at least two places. So the intermediate pouch is where I keep the backups for source code files. I never keep source code I write on my Netbook– though I keep the Netbook with me.
In addition, on both the Macbook and Netbook– I can create MySQL databases which are exact duplicates of those I maintain on my sites. The database driving this blog– is too large so I would never consider duplicating the database locally, but I do back its contents up regularly. I can also create working environments on both platforms which allow me to develop and check the code I write. Both on the Netbook and MacBook. Keep in mind the Netbook is Windows and I can fully recreate my online Unix– PHP, MYSQL environments for testing.
I provide these warnings– because I believe the birthday database is being tampered with. I made entire backups of both sites [hosting-q.com and qisoftware.com on September 29, 2011]. Before that– Aug 2011. It is not every month– but at least every two months. Here is a photo of the current backup disc which contains both sites in their entirety.
9.29.11 site backup discs
Here is a screen grab of how the gz tar files look on the disc:
Contents of 9.29.11 Site backup discs
Have you ever looked at the SQL procedures created when site backups are done? I use Verizon, FiOS so the huge site compressed files [doubly compressed for qisoftware.com] along with the databases only takes about 5 minutes to download. And because the qisoftware.com site is doubly compressed- I can get both sites on one 700 MB disc– just barely.
What am I trying to say? Idiot do not change my sites– nor my databases. I can make you look like all kinds of idiots. I keep too many backups- of everything. I can also recreate most things locally… STOP.
And do not say– I did not try to warn you.. GET OFF MY SITES.
By the way– I have recreated my sites several times with different web hosting providers. I know how to duplicate databases online — also. It is a mistake for you to think I am an idiot. Screwing with my sites? You are the only idiot.
Something else- before I burn the backup disc- I check the integrity of those gz files. Maybe once there was a problem. Mostly– they decompress [qisoftware.com home directory also] without problem. I simply do not place the decompressed folders on the discs– will not fit.