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.

Read More

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.

Read More

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.

Read More

SQL: Speed LIMITs (Using LIMIT for Speed in Your Queries)

Returning a tiny recordset when you or your users login? Your web application may be only one word away from untapped speed! Read More

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.

Read More

Installing and Testing MySQL 4 on Windows

The purpose of this tutorial is to take you through the process of installing MySQL 4 for Windows. This is very important, if you intend to use the PHP/MySQL Server Model within Dreamweaver MX.

For more knowledgeable detail, read Gareth's Premium Article at http://www.dmxzone.com/ShowDetail.asp?NewsId=6738

But at least mine is FREE!!!

Read More

Setting NTFS Folder Permissions for IUSR account

This Tutorial is for Newbies. It is fairly simple to set the Ntfs Folder permissions. So i will just demonstrate here step by step how easy it is Read More

Using DBManager to Configure MySQL

It is sometimes daunting for a beginner to configure and use the MySQL database engine. A good GUI can help no end. My favourite Windows-based GUI is called DBManager, and is available from www.dbtools.com.br.

This tutorial assumes you have read and followed my two earlier tutorials, on installing Apache and PHP, and on installing MySQL.

 

Read More

Inserting Data into Multiple Rows of Database

This is in response to a user that is "looking for a tutorial on inserting data from a UD4 form into multiple rows of a SQL Server database table." Read More

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.

Read More