Jun 23
Optimizing MySQL: Log Slow Queries
This tutorial is the second part of the MySQL Optimization mini series and introduces the Slow Query Log as well as describes its setup and output.
Jun 16
Optimizing MySQL: Configuration
In this first part of the MySQL optimization mini series we'll take a look at configuration directives which have direct influence on MySQL performance.
May 19
Import Structure and Data using phpMyAdmin 3.1
In this extract from Marc Delisle's new book, ‘Mastering phpMyAdmin 3.1 for Effective MySQL Management’, users will learn to bring back exported data created for backup and transfer purposes. They will get an overview of the various options available in phpMyAdmin to import data, and different mechanisms involved in importing SQL and CSV files.
Dec 2
Discover how to interact with MySQL via PHP
This is a tutorial that will show you how to get started using PHP to connect to, and perform various queries on a MySQL database. If you are a PHP programmer, but have no experience with MySQL, this is a great tutorial to get you started.
Aug 18
A Gentle Introduction to SQL
This is an interactive set of tutorials for SQL. Very useful if your are just learning SQL, or if you need a quick reference on how to structure a query.
Jul 16
MySQL Cheat Sheet
This is a basic list of MySQL functions used for retrieving, and manipulating data within your database.