i.justrealized

This guide aims to go through installation of PEAR modules using XAMPP. The module to install is MDB2.

I use XAMPP Lite instead of the full XAMPP but I imagine it to be the similar. My platform is Windows Vista.

0. Objective

To install PEAR module, MDB2, using a XAMPP set up. Also install the MySQL, MySQLi and PostgreSQL drivers.

1. Setting up environment variables

Firstly, we would need to let the command prompt know where to find pear.bat. In my computer set up, it is located in ‘C:\xampp\php\’. Yours might be in ‘C:\xampp-lite\php\’ depending on where you install your XAMPP.

We need to edit some system environment variables:

Click on ‘Edit the system environment variables’, a dialog box will pop up. Click on ‘Environment Variables…’, you should be greeted with the following dialog box:

My path looks like this before I add anything:

Append your XAMPP PHP directory at the back of what is already there:

2. Install MDB2

Now that we have specified the environment variables, the command prompt knows where to find pear.bat. We can now execute the following:

Here’s how the execution look like:

Now we can proceed to install the MySQL driver for MDB2:

To install MySQLi driver for MDB2:

Since you already installed MDB2, the installer will just install the additional drivers like this:

That’s all

You can install other modules in a similar way. To get a list of PEAR commands that you can use:

Hope it works well for you.

Possibly related:

1. How to import and export MySQL database into an SQL file
2. How to run XAMPP’s PHP CLI and CakePHP console
3. How to install Python and Django in Windows Vista
4. How to backup and restore in PostgreSQL

This entry was posted on Tuesday, October 14th, 2008 at 4:42 pm and has been tagged database, mysql, pear, php, postgresql, xampp. Comments RSS feed.