Category Archives: MySQL

The world’s best web database!

Working with Fixed Length Outfiles using MySQL and PHP

Posted on 21-Aug-2006 by Gare

Creating ASCII Fixed Length Outfiles using MySQL Step 1. Create a FileSpecification Mysql table. Step 2. Export your MySQL data using the FileSpecification Table as a map Details: Step 1. Create a FileSpecification Mysql table. Create a File Specification Table: … Continue reading →

Posted in MySQL, Other Tech, WebTechnology | Leave a comment

A.4.2 How to Reset Root Password in MySQL

Posted on 22-Jul-2006 by Gare

If you have forgotten the root user password for MySQL, you can restore it with the following procedure: 1. Take down the mysqld server – kill `cat /mysql-data-directory/hostname.pid` 2. Restart mysld with the –skip-grant-tables option. 3. Connect to the mysqld … Continue reading →

Posted in MySQL, WebTechnology | Leave a comment

MYSQL – export and email automation

Posted on 11-Jan-2006 by Gare

Situation You want to export data from a MYSQL table and email it in .CSV format on a regular schedule. This was on Darwin on Mac OS X server, but works on any similarly configured *Nix of course. Solution Build … Continue reading →

Posted in MySQL, WebTechnology | Leave a comment