Importing Large MySQL Databases – When phpMyAdmin Let’s You Down – Get BigDump

phpMyAdmin phpMyAdmin is a beautiful tool. It let's you administer a MySQL Database without all the messy commands. Also, some host don't even allow you access to those messy commands. So, once again, it's a beautiful tool. You can pull up a window … [Read more...]

Content Management Systems

What is a Content Management System? Here's a little background. Lots of websites have dynamic content. Meaning, the content is located in a database, usually MySQL, and they are simply dumped into a web template when the page is viewed. That way, if … [Read more...]

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 … [Read more...]

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 … [Read more...]

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. … [Read more...]

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 … [Read more...]

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 … [Read more...]