Simple MySQL Database Backup

First off, this is for those of us with our own servers. Not those of us on shared hosts, because we’re going to need access to the command prompt and MySQL commands, etc. Some shared hosts may allow some of these things, but most don’t. Matt Wade Writes: Just a quick note to recommend AutoMySQLBackup for your MySQL backup needs. This little gem does daily, weekly, and monthly backups. It handles all the backup rotations for you.

Installing A LAMP Web Server System With Fedora Core 6

LAMP - Linux, Apache, MySQL, and PHP. These are the elements you will need to start a very robust and reliable web server from the ground up. HowToForge has a brilliant tutorial on how to start everything. Now take note, this is a VERY detailed tutorial. You can’t really go wrong with this tutorial. We got step by step instructions, we go screen shots, we got it all. The Linux platform used is Fedora Core 6.

Arrays to MySQL Dates and Back

Just in case you ever need to do this Arrays to MySQL dates and back. Simple conversion functions to change MySQL dates to arrays, arrays to MySQL dates.

Foundation for an Extensible Website Engine with PHP 5

When developing production sites for clients with little/no HTML experience this is a must. If your web contract does not include maintenance fees, then this is something that you simply must do in order to have your users freely update their websites. It’s a structure which is simple enough to develop and implement. Alejandro Gervasio at DevShed writes: Setting up the Foundation for an Extensible Website Engine with PHP 5

MySQL & SQL Server Performance

I’ve actually been meaning to try this myself, well a variation of it. I would , however be comparing these speeds from a C# Application performing data access to the SQL Sever 2005 or MySQL backend. Based on these tests it seems that I’d be better off with an ASP.NET connection, since this will be running on a windows environment. I will definitely take Karl’s tests into consideration as I perform my own.