Don’t make these stupid mistakes
ID-Ten-T Error
A term often used by tech support operators and computer experts to describe a problem that is due to the user’s ignorance instead of a software or hardware malfunction.
Here is a fun post where I will list out several dumb mistakes I have made with this site since starting it a few weeks ago.
1. Always Backup Your Data
I have been a windows users for probably the past 10 years. Basically since I started using a computer. At the beginning of this year I switched to my first Mac and I love using it however I keep really screwing up my sites when I perform upgrades.
I have Transmit as the ftp client and when I upgrade I just put all the files and tell it to Replace all the files. This does not achieve the effect I want. Yes it replaces the files but also deletes all the files that are not getting overwritten. So basically I loose important files that would otherwise remain uploaded.
2. Never drop all your database tables
This one is pretty obvious but it caught me.
While creating the install for 68kb I added this little portion of code to drop all the tables before installing.
$tables = $this->db->list_tables();
foreach($tables as $table)
{
$sSQL="DROP TABLE IF EXISTS ".$table;
$this->db->query($sSQL);
}
It seemed fine at the time because I was running on localhost and it didn’t matter if all the tables where removed. I uploaded this to the server and decided to install it in the same database as the site and guess what happened.
I am sure you guessed correct. Everything was gone!
The only plus side was Google had a few of the pages and posts cached so I could rebuild what they had.
Now that I have shared my stupid mistakes why don’t you share yours?
November 15, 2007
0 comments
Kick things off by filling out the form below.
Leave a Comment