Using MySQL Full-text Searching

Beginner Tutorials - Using MySQL Full-text Searching

***UPDATE
I found this link, explains the full text search much better:
http://www.phpfreaks.com/tutorials/129/1.php

Optimizing MySQL: Queries and Indexes

Found a good article that helps explain how to use MySQL Indexes in your database tables. Databases are great, but if they are large and you do not have your-indexes-in-a-row they can slow down to a crawl. Have not had any problems with the HHR db, but this should help speed it up and prevent any problems in the future.

Auto MySQL Backup Script

Here is an automatic MySQL backup tool that will email the backup to you, ftp it somewhere or just drop it to a directory. Pretty cool. Easy to setup with a CronJob.

AutoMySQLBackup Cron Job Script

MySQL Database Design

Found this article while look for reference on MySQL data types. Ended up looking over the whole thing. Turns out it’s a pretty good for starting MySQL db development.

MySQL Database Design