Timothy E. Archer

phpMyAdmin is a wonderful tool which allows you to use your web browser to administer your MySQL databases. It gives you a nice GUI to “create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges, [and] export data into various formats”.

This quick start is designed to help you get phpMyAdmin up and running lighting fast. I am currently running RedHat Linux AS3. Apache and php are already configured and running on my server. This post concentrates only on the specifics to installing phpMyAdmin 2.10.0.2.

1) Download phpMyAdmin from the download page at http://www.phpmyadmin.net/home_page/downloads.php

I downloaded the file named english.tar.bz2.

2) Unzip phpMyAdmin:

bunzip2 phpMyAdmin-2.10.0.2-english.tar.bz2

continue reading…

Are you looking to backup your MySQL database? My site runs with MySQL as its backend database, and as such I wanted a backup script I can just drop in.

I have found a great open source utility called AutoMySQLBackup which can be downloaded from SourceForge.net. There is no need to reinvent the wheel writing your own, this one works extremely well.

Here are the steps I followed to configure this script: continue reading…