WAMP: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 16: Line 16:


=== EasyPHP ===
=== EasyPHP ===
* [[http://www.easyphp.org/ Easy PHP]].
* [http://www.easyphp.org/ Easy PHP].
* Used to be a good package, but supports older versions of PHP and MySQL
* Used to be a good package, but supports older versions of PHP and MySQL


; Upgrade of EasyPHP
; Upgrade of EasyPHP
Easyphp 1.8 (current on 16:11, 4 December 2006 (MET)) does only PHP 4, but you can upgrade:
Easyphp 1.8 (current on 16:14, 4 December 2006 (MET)) does only PHP 4, but you can upgrade:
* Empty the ./php directory and http://www.php.net/downloads.php
* Empty the ./php directory and http://www.php.net/downloads.php
** IMPORTANT: Edit php.ini and '''explicitly''' load php_mysql (for the php 4 this was not necessary)
** IMPORTANT: Edit php.ini and '''explicitly''' load php_mysql (for the php 4 this was not necessary)
Line 28: Line 28:
=== WAMP5 / WAMPServer ===
=== WAMP5 / WAMPServer ===


* [[http://www.wampserver.com WampServer]] (also on SourceForge)
* [http://www.wampserver.com WampServer] (also on SourceForge)
* Supports PHP 5x and MySQL 5x (16:11, 4 December 2006 (MET)).
* Supports PHP 5x and MySQL 5x (16:14, 4 December 2006 (MET)).
* This may be the best bet, but [[User:DSchneider|DSchneider]] didn't do any serious testing.
* This may be the best bet, but [[User:DSchneider|DSchneider]] didn't do any serious testing.


Line 38: Line 38:
From [http://tecfa.unige.ch/guides/tie/html/tie-wiki/tie-wiki.html]:
From [http://tecfa.unige.ch/guides/tie/html/tie-wiki/tie-wiki.html]:
; Export / dump the database on your server
; Export / dump the database on your server
Export your database on the server and transfer the file to your PC
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
  mysqldump -p base_de_donnees > fichier.sql
Example: mysqldump -p wikimedia > /tmp/wikimedia.sql
Example:  
mysqldump -p wikimedia > /tmp/wikimedia.sql


; Import the database in your PC
; Import the database in your PC
Line 52: Line 53:
  c:\wamp\mysql\bin\mysql.exe
  c:\wamp\mysql\bin\mysql.exe


Open a terminal (DOS window, command prompt, or whatever it is called) and type:
Open a terminal (DOS window, command prompt, or whatever it is called) and use this construct:
  mysql.exe base_de_donnees -u root -p < c:\tmp\wikimedia.sql  
  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 ...
Then wait a good moment ...

Revision as of 17:14, 4 December 2006

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.

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:14, 4 December 2006 (MET)) does only PHP 4, but you can upgrade:

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

WAMP5 / WAMPServer

  • WampServer (also on SourceForge)
  • Supports PHP 5x and MySQL 5x (16:14, 4 December 2006 (MET)).
  • This may be the best bet, but DSchneider didn't do any serious testing.

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 simple use the root)
    • change the IP Number
    • Vérifier le include path (les anciens, genre Mediawiki 1.5 était fait pour Unix)
$path = array( $IP, "$IP/includes", "$IP/languages" );
set_include_path( implode( PATH_SEPARATOR, $path ) );
require_once( "includes/DefaultSettings.php" );
Short URLs

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