(Todd Farmer) There’s a lot of great new features in MySQL 5.6 DMRs – almost too many to keep track of. And while a lot of (justified) attention is given to the headline-grabbing features of 5.6 (memcached APIs! global transaction ids! improved PERFORMANCE_SCHEMA!), I’m often curious about the new

(Ronald Bradford) A recent question on a mailing list was the best practices for UTF-8 and PHP/MySQL. The following are the configurations I used in my multi-language projects.

(Shlomi Noach) You have been told (guilty as charged), that the only way to get rid of the huge InnoDB tablespace file (commonly named ibdata1), when moving to innodb_file_per_table, is to do a logical dump of your data, completely erase everything, then import the dump.

(Rob Gravelle) In this follow-up to the Automate Database Backups with MySqlDump and PowerShell article, we’ll be exploring the other side of the equation and learn how to restore a MySQL database from backup in the event of a rollback or disaster recovery.

(Dathan Pattishall) I have been looking for efficient ways to purge data from “Fast Disks” for applications that are time based and do not look at data after a time window has passed. For instance keeping a table where one stores log data from access logs and the data is okay to roll up the data and

(Ronald Speelman) Below you will find all code to create the table and the stored procedures to manage hierarchical trees in MySQL.

(Leo Hsu and Regina Obe) One new welcome feature in PostgreSQL 9.2 is the native json support and companion row_as_json and array_as_json functions. PostGIS also has a json function for outputting geographies and geometries in GeoJson format which is almost a standard in web mapping.

(Rob Gravelle) The INFORMATION_SCHEMA database is where each MySQL instance stores information about all the other databases that the MySQL server maintains. Also sometimes referred to as the data dictionary and system catalog, it’s the ideal place to lookup information such as the name of a databa

(Leo Hsu and Regina Obe) One of the things I’m excited about in PostgreSQL 9.2 are the new pg_dump section – pre-data, data, and post-data options and the exclude-table-data option. Andrew Dunstan blogged about this briefly in pg_dump exclude table data. What is also nice is that pgAdmin III 1.16 su

(Rob Gravelle) One of the Database Administrator (DBA)’s most important duties is performing regular scheduled database backups. Equally important is the maintenance of the backup files and practicing of the restoration procedure. All in all, it can be a time intensive endeavor.