WAMP: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 21: Line 21:
* Supports PHP 5x and MySQL 5x (16:16, 4 December 2006 (MET)).
* Supports PHP 5x and MySQL 5x (16:16, 4 December 2006 (MET)).
* This may be the best bet currently, but [[User:DSchneider|DSchneider]] didn't do any serious comparative testing.
* This may be the best bet currently, but [[User:DSchneider|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.
* Only thing missing were some mysql excutables that some programs or yourself may need for command line operations (e.g. [[LAMS]] installer needs this).


=== 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 the most popular PHP 4.x package
* [[User:Daniel K. Schneider|Daniel K. Schneider]] did not test the 2.0beta version yet (mai 2007).


; Upgrade of EasyPHP
; How to upgrade EasyPHP if you really need to
Easyphp 1.8 (current on 16:16, 4 December 2006 (MET)) does only PHP 4, but you can upgrade:
I once managed to upgrade PHP4.x to PHP5.x in Easyphp 1.8 (in nov 2006)
* Empty the ./php directory and http://www.php.net/downloads.php
* Empty the ./php directory and get [http://www.php.net/downloads.php PHP] from PHP
** IMPORTANT: Edit php.ini and '''explicitly''' load php_mysql (for the php 4 this was not necessary)
* Edit php.ini and '''explicitly''' load php_mysql (for the php 4 this was not necessary)
  extensions_dir = "./ext"
  extensions_dir = "./ext"
  extensions = php_mysql.dll
  extensions = php_mysql.dll
Line 39: Line 40:
* Not tested by [[User:DSchneider|DSchneider]].
* Not tested by [[User:DSchneider|DSchneider]].


== Running a mediawiki on your travail PC ==
== Running a mediawiki on your travel PC ==


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


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
; If you want to clone a Mediawiki from your "real" server:
Export your database on the server and transfer the file to your PC (e.g. to c:\tmp\wikimedia.sql):
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
Line 53: Line 54:
Firstly create a database on you PC-based MysQL server
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).
I suggest to use the command line to do the import, because file upload is limited in a typical PHP installation (else reconfigure the parameters in the php.ini file).


In EasyPHP 1.8 the mysql.exe program is here:
In EasyPHP 1.8 the mysql.exe program is here:
Line 65: Line 66:
  mysql.exe wikidb -u root -p < c:\tmp\wikimedia.sql  
  mysql.exe wikidb -u root -p < c:\tmp\wikimedia.sql  


Then wait a good moment ...
Then wait for a long moment ...


; Copy the MediaWiki server
; Copy the MediaWiki server


* Adapt LocalSettings.php
* I suggest to zip the files on the serveur and then dezip exactly in the same place
 
Then, adapt the LocalSettings.php file
** Change the DataBase user and password (on the PC I simply use the root)
** Change the DataBase user and password (on the PC I simply use the root)
** change the IP Number
** You may have to ajust other things too, if you use short URLs on your production server, you may want to fix the Apache configuration on your PC too.
 
See [[ManageMediaWiki]], my somewhat disorganized English/French installation MediaWiki management notes.


; Short URLs


If you use short URLs on your production server, fix the Apache configuration on your PC too.
[[Category: Installation tips]]

Revision as of 10:50, 4 May 2007

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 (e.g. LAMS installer needs this).

EasyPHP

How to upgrade EasyPHP if you really need to

I once managed to upgrade PHP4.x to PHP5.x in Easyphp 1.8 (in nov 2006)

  • Empty the ./php directory and get PHP from PHP
  • Edit php.ini and explicitly load php_mysql (for the php 4 this was not necessary)
extensions_dir = "./ext"
extensions = php_mysql.dll

XAMPP

Running a mediawiki on your travel PC

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

From [1]:

If you want to clone a Mediawiki from your "real" 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 parameters 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 for a long moment ...

Copy the MediaWiki server
  • I suggest to zip the files on the serveur and then dezip exactly in the same place

Then, adapt the LocalSettings.php file

    • Change the DataBase user and password (on the PC I simply use the root)
    • You may have to ajust other things too, if you use short URLs on your production server, you may want to fix the Apache configuration on your PC too.

See ManageMediaWiki, my somewhat disorganized English/French installation MediaWiki management notes.