Man, what a week it has been. As you may have noticed it's been a few days too many since my last post. The reason for that is a hectic week at work has prevented me from having time.
Now that the week is over and it was hectic because of my own stupidity, I mine as well write an article about it to save you some time.
On Tuesday, my client gave me the go ahead to launch 3 months of development work live. We had been testing it for several weeks off and on making some tweaks and everything had been running quite smoothly.
So, I gathered up the SQL commands to create the new tables, alter the existing ones, populate a few new ones, etc... Zipped up the new code, uploaded it to the server, extracted it and we were good to go. 3 months of development work was now live.
I had a co-worker help me test out the new work. Everything went smoothly. It had to be the smoothest launch ever, until of course I said that it was the smoothest launch ever...
The next day, a few leaks in the hose seemed to be appearing, we weren't really sure what was happening, but something certainly was. The night I came down with the flu and all hell broke loose on Thursday while I was at home extremely sick.
Along came Friday and still not feeling well, I went in and made a few fixes, got things somewhat better.
The moral of this story is, we could have avoided some major headaches if prior to releasing three months of code if we would have run to simple commands.
First one would be to backup our Mysql database:
And the second line would be to backup our code:
The next time, no matter how small or big the work is, you can guarantee those are the first two things I will do! Published on Feb 22, 2009 Tags: SQL Tutorials for Beginners, Intermediate and Advanced Users
| gzip
| Theory
Did you enjoy this article? If you did here are some more articles that I thought you will enjoy as they are very similar to the article
that you just finished reading.
Jamie Munro is the author of ASP.NET MVC 5 with Bootstrap and Knockout.js,
Knockout.js: Building Dynamic Client-Side Web Applications,
20 Recipes for Programming MVC 3,
and 20 Recipes for Programming PhoneGap. He has been developing websites and web applications for over 20 years. Jamie began his writing career in 2009. As the success of Jamie's blog grew, he turned his writing passion to books about web development in hopes that his many years of experience could be passed on to his readers. No matter the programming language you're looking to learn, I've hopefully compiled an incredible set of tutorials for you to learn; whether you are beginner
or an expert, there is something for everyone to learn. Each topic I go in-depth and provide many examples throughout. I can't wait for you to dig in
and improve your skillset with any of the tutorials below.
mysqldump -u [username] -p [password] [databasename] > [backupfile.sql]
tar -cvf - <directory name> | gzip -c > <directory name>.tar.gz
Related Posts
Tutorials
Learn how to code in HTML, CSS, JavaScript, Python, Ruby, PHP, Java, C#, SQL, and more.