WAMP

The educational technology and digital learning wiki
Jump to navigation Jump to search

Draft

Definition

The acronym WAMP (or Q.A.M.P.) refers to a set of free software programs commonly used together to run dynamic Web sites or servers:

  • Windows, the operating system;
  • Apache, the Web server;
  • MySQL, the database management system
  • The PHP (and sometimes the Perl or Python) programming languages.

See LAMP, the original Linux-based solution

WAMP for Windows products

For the Windows world there exist several complete packages that come with installers and a launch/stop/configure tool. Some also work for Linux, but I'd rather not use them on a real server.

WAMP5 / WAMPServer

  • WampServer
  • Also available on SourceForge (try this if the other is down)
  • Supports PHP 5x and MySQL 5x (16:16, 4 December 2006 (MET)).
  • This may be the best bet currently, but DSchneider didn't do any serious comparative testing.
  • Only thing missing were some mysql excutables that some programs or yourself may need for command line operations.

EasyPHP

  • Easy PHP.
  • Used to be a good package, but supports older versions of PHP and MySQL
Upgrade of EasyPHP

Easyphp 1.8 (current on 16:16, 4 December 2006 (MET)) does only PHP 4, but you can upgrade:

extensions_dir = "./ext"
extensions = php_mysql.dll

XAMPP

Running a mediawiki on your travail PC

To run Mediawiki 1.7 (and better) you need to have PHP 5.0 installed !

From [1]:

Export / dump the database on your server

Export your database on the server and transfer the file to your PC (e.g. to c:\tmp\wikimedia.sql):

mysqldump -p base_de_donnees > fichier.sql

Example:

mysqldump -p wikimedia > /tmp/wikimedia.sql
Import the database in your PC

Firstly create a database on you PC-based MysQL server

I suggest to use the command line to do the import, because file upload is limited in a typical PHP installation (else reconfigure the paramters in the php.ini file).

In EasyPHP 1.8 the mysql.exe program is here:

\program files\Easyphp-XX\mysql\bin\mysql.exe

In WAMP 5, the file is here:

c:\wamp\mysql\bin\mysql.exe

Open a terminal (DOS window, command prompt, or whatever it is called) and use this construct:

mysql.exe base_de_donnees -u root -p < path_to_sql_dump.sql

Example:

mysql.exe wikidb -u root -p < c:\tmp\wikimedia.sql 

Then wait a good moment ...

Copy the MediaWiki server
  • Adapt LocalSettings.php
    • Change the DataBase user and password (on the PC I simply use the root)
    • change the IP Number
Short URLs

If you use short URLs on your production server, fix the Apache configuration on your PC too.