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.
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.
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.
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:
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.
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!!!
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.
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.