making sense of web design
MySQL
Using MySQL Full-text Searching
Mar 14th
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
Feb 27th
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 More >
Auto MySQL Backup Script
Feb 25th
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
Oct 21st
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
Recent Comments