How To Automatically Backup MySQL Databases to Your Computer

How often do your online databases get updated? How often do you back up? Are you dependent on your host for backups? Try this quick PHP script to backup your MySQL databases from your server.
The general rule of thumb for backups is backup often enough to where you wont mind losing the work [...]

Bridging Etomite and SMF

A few months ago I started a photography forum with another moderator from a previous forum I was on. Part of our goal was to have a library of articles in a static site and link those articles back to a Simple Machines forum for discussion.
For the CMS I decided on Etomite since I’ve [...]

Get list of MySQL databases using PHP

MySQL has a built-in command to get a list of databases that can be accessed by the currently logged in user, and it is very easy to take this list and use it inside a PHP script.
First, let's look at the command from inside the MySQL monitor ptogram. If you have any experience inside [...]

Get MySQL version using PHP

Many web based applications need to know what version of MySQL they are using. Fortunately MySQL has a built in command that will return the version as part of a query. Just enter the following command at the MySQL prompt and the server will return the version.

If you're needing to get the version [...]

How to install Menalto Gallery 2

If you're looking to start an online photo gallery, Menalto Gallery may be a good fit for you. It's free and open-source so you don't have to spend any money for it and you can customize it as much as you want with a little PHP skill.
Downloading
The Gallery download page has several packages that [...]