This is a "copy & paste" HowTo! The easiest way to follow this tutorial is to use a command line client/SSH client (like PuTTY for Windows) and simply copy and paste the commands (except where you have to provide own information like IP addresses, hostnames, passwords,...). This helps to avoid typos. How To Set Up Database Replication In MySQL How To Set Up Database Replication In MySQ
MySQL Gotchas Notes 1. This is not an "anti-MySQL" list, although it does contain critical comments; 2. MySQL is continually improving and some of the points listed here are no longer valid for recent versions; 3. This list is regularly updated, but may not always reflect the latest developments (unfortunately I've been busy the past couple of months and haven't had time for the site at all; watch this space ;-). Note to Slashdot readers: this page deals with issues related to MySQL 4.1 and earlier, not 5.0 4. There's a list for PostgreSQL too. 5.
Make MySQL faster in one hour There may be a simple way to improve InnoDB performance on SMP servers. The benefit is not as great as that obtained by using the smpfix from Google or Percona, but the change is much simpler. It is also portable so it makes MySQL faster on non-x86 platforms. I want to hear from people who test this with real workloads on servers with 8+ cores or who do any type of testing on platforms other than Linux/x86.
15.3.4 Using MySQL and me
We talked about duplicating with MySQL earlier, and another MySQL tip worth pointing out is on inserting or updating in one query. The idea is that there will be times when you would like to update a record if it exists, or insert if it does not exist. This becomes especially true in the world of web 2.0 and API’s where the return value may come over a delay. To Insert or To Update
PHP MySQL Tutorial
SQL Injection Cheat Sheet
MySQL Quick Admin - Free MySQL Web GUI
PHP & MySQL : Generating an RSS feed Published March 29, 2004, 3:32 pm by Neerav Bhatt This article was presented at the March 2004 Sydney PHP Group Meeting. PHP & MySQL : Generating an RSS feed - Presentations & A
Storing Hierarchical Data in a Database [PHP & MySQL Tutoria This article was written in 2003 and remains one of our most popular posts. If you’re keen to learn more about mastering database management, you may find this recent article on MySQL of great interest. Whether you want to build your own forum, publish the messages from a mailing list on your Website, or write your own cms: there will be a moment that you’ll want to store hierarchical data in a database. And, unless you’re using a XML-like database, tables aren’t hierarchical; they’re just a flat list. You’ll have to find a way to translate the hierarchy in a flat file.
Common MySQL Queries Basic aggregation Last updated 05 Jan 2013 Aggregate across columns Last updated 09 Sep 2009 Common Queries
I’ve attempted to keep my queries as simple as possible, but I assume that you have a basic understanding of databases and the SQL language (more specifically, MySQL’s implementation of it). I also assume you have MySQL 3.23, as a few of these queries may not work on 3.22. If you don’t have MySQL 3.23 yet, I highly recommend you install it if possible, as some of the performance increases are significant. What are Indexes? Indexes are organized versions of specific columns in your tables. MySQL uses indexes to facilitate quick retrieval of records. Optimizing your MySQL Application [PHP & MySQL Tutorials]
Dan Winchester - MySQL date_format
MySQL 5.0 Reference Manual