(Paul Dubois) Because MySQL tables are stored as files, it is easy to do a backup. To get a consistent backup, do a LOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables. You need only a read lock; this allows other clients to continue to query the tables while you are making a

(Melonfire) Transactional support has long been on the wish list of most MySQL developers and, with the release of MySQL 4.0, this wish was finally granted. Not long after MySQL 4.0, PHP 5.x was released with a new MySQL extension, MySQL Improved, which allowed PHP developers to access these new tra

Here is a list of a few very simple tips for optimizing your php/mysql applications. Keep these in mind while developing.

(Alejandro Gervasio) If you’re interested in learning how to combine objects, sessions and MySQL, this is the article that you’ve been waiting for. It’s the final part of the series “Serializing objects in PHP.” In three parts, this series goes through the fundamentals of serializing objects in PHP

(Michael Rogne) It is extremely common these days to make results display across multiple pages. Some examples are maybe browsing through picture galleries, store products, blog entries, etc.

(Darryl K. Taft) A group of leading user companies, vendors and other organizations plans to launch an open message queuing protocol that will enable users to create systems that compete with or replace proprietary technology.

(Paul Musich) IBM said that it has released software to the Apache Open Source Foundation designed to help automate the detection and remediation application or transaction problems in the data center.

(Paul Dubois) This section describes how to set up accounts for clients of your MySQL server. It discusses the following topics: –The meaning of account names and passwords as used in MySQL and how that compares to names and passwords used by your operating system –How to set up new accounts a

(Ed Burnette) You’ve made the decision to release your code as “open source”. Ok, what does that mean, what is an open source license, and how do you pick the right one? This question comes up all the time so I thought I’d write up a simple decision tree to try to explain the choices. This isn’t leg

(Paul Graham) Lately companies have been paying more attention to open source. Ten years ago there seemed a real danger Microsoft would extend its monopoly to servers. It seems safe to say now that open source has prevented that. A recent survey found 52% of companies are replacing Windows servers w