Linux Journal

Recover a MySQL Table with Zmanda Recovery Manager

If somebody accidentally drops a critical table in MySQL, the application no longer works. The solution to this problem is to utilize the (open source) Zmanda Recovery Manager. You are a MySQL ...
Houston Chronicle

Fastest Way to Check if MYSQL Table Exists in PHP

Dynamic PHP pages give you the option to choose a MySQL table dynamically from which to query. You must ensure that the table exists before running a query on the table. PHP has a quick function that ...
TechRepublic

How to add data into MySQL tables from the command line

Jack Wallen explains how to add data into a MySQL table from the command line. So you’re new to MySQL database administration. You’ve probably already installed ...
Ars Technica

MySQL table join on fields whose size don't match?

I'm the lucky winnar that inherits a php (problem?) project to add functionality to a database-driven website... all the fields that i need are there, they just happen to be in about 3-4 different ...
Visual Studio Magazine

Access MySQL Database With PHP

To install the MySQL database, you must first download the community edition of MySQL 5.0 database for Windows. There are three versions: Windows Essentials (x86), Windows (x86) ZIP/Setup.EXE and ...
Ars Technica

Recursively delete items in a MySQL table - foreign key, or something else?

I'm working on a web app, and it part of it, there is a very simple database-driven file/document manager. As a file manager, there is the possibility of sub-folders. So in the DB, I have the ...