How To Set Up Database Replication In MySQL
This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync.

MySQL Crash Tutorial
One of the most-used SQL tutorials in the world, with an emphasis on teaching what you really need to knowmethodically, systematically, and simply.

Backing Up And Restoring Your MySQL Database
If you've been using MySQL database to store your important data, it is imperative that you make a backup of your data to prevent any loss of data. This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server.

Optimizing MySQL Queries and Indexes
Building a database-driven site is one thing. But all too often your masterpiece starts performing like a donkey when it becomes popular. Learn how to optimize your queries and indexes in MySQL, and potentially speed up your application many times over.

Using a MySQL database with PHP
It's time to add some dynamic content to your website. The best choice for ease-of-use, price and support is the combination of PHP and MySQL. This article introduces the beginner to using MySQL with PHP.

Build Your Own Database Driven Website Using PHP & MySQL: Part 1
Together, PHP & MySQL form the most widely used open source database and scripting technologies on the Web today. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.

Build Your Own Database Driven Website Using PHP & MySQL: Part 2
This second installment covers an introduction to databases, logging on to MySQL, defininfg SQL, inserting data into a table, and modifying stored data.

Build Your Own Database Driven Website Using PHP & MySQL: Part 3
This third installment introduces PHP, variables and operators, user interaction and forms, control structures, and multi-purpose pages.

Build Your Own Database Driven Website Using PHP & MySQL: Part 4
This final installment covers publishing MySQL data on the Web, connecting to MySQL with PHP, sending SQL queries with PHP, inserting data into the database, and even has a "homework" assignment. This book covers everything from installing PHP & MySQL under Windows or Linux, through to building a live Web-based content management system.

Optimizing MySQL, Hardware and the Mysqld Variables
You've fine-tuned your indexes, and have optimized those queries to the bone. But still your MySQL database is crawling. It's time to look at tweaking the mysqld variables, what hardware improvements you can make, and how you can compile MySQL to run just that little bit faster.

Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them...

Installing MySQL
Learn how to obtain and install MySQL.

Introduction to MySQL
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database.

Connecting to and Disconnecting from the Server
Before you can start running your queries you need to get your client talking with your server.

Entering Queries
This section describes the basic principles of entering commands, using several queries you can try out to familiarise yourself with how mysql works.