Web Tools

How to Restore a Database Using phpMyAdmin

This tutorial is for phpMyAdmin version 3.5.5. It may be the same or similar for other versions, but no guarantee is made. Note: the preferred method to restore your database is to use the restore database service provided by your web host. If your web host does not provide such services, then you can use […]

Web Tools

How to Backup a Database Using phpMyAdmin

This tutorial is for phpMyAdmin version 3.5.5. It is probably the same for other versions, but no guarantee is made. Note: the preferred method to backup a database is to use the backup database service provided by your web host. If your web host does not provide such services, then you can use this method […]

Web Tools

Creating a MySQL Database Using AMPPS

This tutorial assumes that you have AMPSS 1.2 installed. The procedure should be the same for other versions of AMPPS. An AMPPS installation procedure for Windows XP can be found here. Normally, you would not need to create a database in AMPPS because the setup script will automatically do that for you. However, if you […]

Web Tools

Installing AMPPS – Apache Server, MySql, PHP, Perl with Installation Scripts

These instructions are for installing AMPPS 1.2 on Windows XP with Service Pack 3. It should work for other configurations as well. Some images may be clicked for full sized versions. AMPPS is an extremely easy to install and use Apache Server which comes bundled with MySQL (a database), PHP (server side scripting language), Perl […]

Web Tools

Adding a New User to a MySql database in XAMPP

This tutorial assumes that you have XAMPP 1.7.3 installed. The procedure should be the same for other versions of XAMPP. A XAMPP installation procedure for Windows XP can be found here. Click on images for full sized versions. (1) Enter http://localhost/phpmyadmin into your browser’s URL field. This will bring you to the phpmyadmin main page. […]

Web Tools

How to Add a Password to the XAMPP root User

This is NOT recommended! By default, databases in XAMPP are created with the user root having a blank password. This poses a security risk if the computer or database are publically accessible. However, for local development and testing, this should not be a problem. This tutorial assumes that you have XAMPP 1.7.3 installed. The procedure […]

Web Tools

Deleting a MySql Database Under XAMPP

This tutorial assumes that you have XAMPP 1.7.3 installed. The procedure should be the same for other versions of XAMPP. A XAMPP installation procedure for Windows XP can be found here. Click on images for full sized versions. (1) Enter http://localhost/phpmyadmin into your browser’s URL field. This will bring you to the phpmyadmin main page. […]

Web Tools

Creating a MySQL Database using XAMPP

This tutorial assumes that you have XAMPP 1.7.3 installed. The procedure should be the same for other versions of XAMPP. A XAMPP installation procedure for Windows can be found here. Click on images for full sized versions. Many applications, such as Joomla! require an SQL database as part of their setup. With XAMPP installed, this […]

Web Tools

Installing XAMPP – Apache Server, MySql, and PHP

These instructions are for installing XAMPP 1.7.3 on Windows XP, Service Pack 3. It should work for other configurations as well. XAMPP 1.7.4 (released in January 2011). I had no problem with the install and most things work just fine, however, there are many little things that require “expert” tinkering to get it working right. […]