A MySQL Abstraction Class For PHP

Tags: database abstraction, mysql, pear, php
Posted 496 days ago.

Over the time I have been working with PHP, I built a library of useful classes for my projects. I have always wanted to publish this library freely. It will take some time to clean up the code base and comments, but if someone has use for it, then I will be glad to do it.

Duplicate a MySQL Database

Tags: mysql
Posted 541 days ago.

This shell command will duplicate an existing database:

# mysqladmin create DB_name -u DB_user --password=DB_pass && \
mysqldump -u DB_user --password=DB_pass DB_name | mysql -u DB_user --password=DB_pass -h DB_host DB_name

Replace DB_* with your MySQL settings. Where could this be useful besides making a mirror backup of a database?