WAMP: Difference between revisions
(using an external editor) |
m (using an external editor) |
||
Line 16: | Line 16: | ||
=== EasyPHP === | === EasyPHP === | ||
* | * [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: | 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) | ||
* Supports PHP 5x and MySQL 5x (16: | * 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 | |||
; 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 | 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 16:14, 4 December 2006
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:
- 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)
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.