Back to Top
The nuts and bolts for
Creative web development

MySQL Point-in-Time Data Recovery

A utility like mysqldump is very useful for backing up MySQL data and table schema. However, backups are usually made only once a day or at some other regular interval. If data is lost on your system several hours after the last backup is completed, you may not be able to recover it. There are a few methods by which you can continuously protect data. One method that you can use to be able to recover interim data is to use binary logs. A binary log will record all SQL transactions on a server as they are executed. Some administrators try to minimize any logging because of concerns about server performance. However, on average, binary logging will slow a server by only one percent. In return, though, it allows for up to the minute data recovery.

April 28, 2005 Author: Chris Charlton Rating:

MySQL 5.0 New Feature: Views

This book is for the long-time MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL 5.0 New Features series, and this [tutorial] is the third in that series.

What I'm hoping to do is make this look like a hands-on session where you, as if you're working it out yourself on your keyboard, can walk through the sample problems. To do this, I'll go through each little item, building up slowly. By the end, I'll be showing larger views that do something useful, as well as some things that you might have thought were tough.

March 30, 2005 Author: Chris Charlton Rating: Not enough votes

MySQL 5.0 New Features: Stored Procedures

This 67 page guide is for long-time MySQL users who want to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, information_schema". The long answer is the MySQL 5.0 New Features series, and this book is the first in the series.

March 24, 2005 Author: Chris Charlton Rating:

Configuring a Dreamweaver MX site with phAkt and Firebird

Configuring a Dreamweaver MX Site Using phAkt and Firebird

Recent DMXZone Premium articles on using Firebird have inspired me to try connecting to a Firebird database, using the phAkt PHP_ADODB server model.

phAkt can be downloaded from:
http://www.interaktonline.com/products/PHAkt/

 

Please note that the Server Model for this exercise is actually PHP PHAkt 2 for DWMX and MX2004, not PHAkt 1 (UD4) as shown above, but the submission form doesn't give that option.

July 16, 2004 Author: Paul Taylor Rating: Not enough votes

Switching from ODBC to OLE DB

ODBC is the comonly used way to power your database driver apps, OLE DB will improve not only speed but will also be more reliable.

What i will show you in this tutorial is two ways to switch between ODBC to OLE DB.

July 18, 2003 Author: Dave Joosten Rating: