Migrate moodle 1.9.4+ to another computer

Set up a new Windows server and migrate moodle site to it

1. moodle database

2. moodle directory

3. moodledata directory

http://www.iis.net/download/FastCGI

download FastCGI 1.5 for IIS 6 and 5.1

Install it

http://windows.php.net/download/

VC9 x86 Thread Safe -----Installer

Install it with FastCGI option

create a php test script

Test it.

download and Install mySQL

Create the moodle database

mysql -u root -p

CREATE DATABASE moodle;

ALTER DATABASE moodle DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO root@localhost IDENTIFIED BY 'yourpassword';

Follow Install Moodle

IIS

Point home directory to moodle directory

http://localhost/install.php

web access:http://moodle.vanarts.com

After the moodle site is functional, Restore moodle database:

 mysql –u root -p moodle < mysqlDatabase.sql

copy the moodledata directories from old server to the new server.

copy plugin modules (mrbs, gapps,dialogue, and exercise) from old server to new server

The moodle site works but user functions don't work, such as cannot add a new user.

download moodle 1.9.14

Extract it and replace the moodle code with the new one.

Access the moodle site and the upgrading process will begin. After upgrading completes, the user functions are available.