MySQL Tutorials

Check MySQL Database Size
In: MySQL / Miscellaneous
Tutorial teach administrator using a query to checking database size...

MySQL Repair Crashed Table
In: MySQL / Tables and Fields
Tutorial to teach MySQL administrator on repair tables that being corrupted...

MySQL Max_allowed_packet & MySQL Gone Away Problem
In: MySQL / Miscellaneous
Tutorial to solve the MySQL gone away issue by change the max_allowed_packet size...

Reset MySQL Root Password
In: MySQL / Miscellaneous
Tutorial teach administrator on how to reset MySQL root password if forgotten. But, this technique require the server root...

Optimizing MySQL Queries and Indexes
In: MySQL / Miscellaneous
Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it...

Backing Up and Restoring Your MySQL Database
In: MySQL / Basics
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to...

Using MySQL Database with PHP Programming
In: MySQL / Basics
Now it is time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination...

Optimizing MySQL, Hardware and The MySQLD Variables
In: MySQL / Miscellaneous
You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. ...

Database Driven Website Using PHP & MySQL: Part 4
In: MySQL / Miscellaneous
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP...

Database Driven Website Using PHP & MySQL: Part 3
In: MySQL / Miscellaneous
This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi...