Our company is comtemplating moving our moodle installation from a Windows 2000 server to a linux (debian) distribution. What would be the best migration path? Is it as simple as to copy/paste?
The simplest migration IMHO is to export the present courses and to import them in the new server.
::::::ducking for cover::::::
and in which format?
If you just want to transport content from a Moodle installation to another Moodle than backup feature is also the export. (Backup here, restore there.)
If you don't have many courses, you can backup them one-by-one and restore in the new server. Admittedly not very elegant.
P.S. I know the reply is a bit late
The steps of going Windows to Linux is pretty much the same as Linux to Windows. If you search Moodle, you will find various discussions on the steps to migrate between two different OSs.
1. Install AMP on Linux
3. On Linux, import the moodle database with mySQL adminsitration
4. Copy/FTP the MoodleData folder from Windows to Linux
4. Install Moodle to update everything.
As a side note, I'm a fan of XAMPP as I can have almost duplicate XAMPP/Moodle setups on Windows, Linux and Solaris. The only difference is the drive designator in Windows and Windows CRON. Makes for easier management.
Mine is a slightly different question, which i cannot seem to find an answer for, then again it may not be that different.
At the moment we are running a windows 2003 server, with sharepoint and MSSQL, i am hoping to migrate to a *nix server, running apache and mysql.
Originally i was using the sharepoint services because we were going to use webdav to hang the students "my docs" off it, but i have seen a nice little moodle plugin that seems to allow me to attach the students "my docs", but it only runs on linux based moodle servers.
Apart from the export > import route of the the courses etc. how do i export and import the database.
If only that was available for Moodle 1.9.
Well, actually, we are in the process of getting some new servers for moodle.org, and as part of the pre-deployment testing we are doing, we wanted to compare performance on MySQL and Postgres. We were able to trick the 2.0 transfer script into transferring a Moodle 1.9 database. It is an ugly hack, but we made it work. We even documented the steps necessary: Hacking_the_Moodle_2.0_database_transfer_script_to_convert_a_Moodle_1.9_site
But to summarise one thing we have found so far:
- With MySQL, when you hammer the server this hard, you get errors from a few of the page load attempts.
- With Postgres, you don't get errors, and it is only a little bit slower then MySQL the first time (but then you get the weird thing that starts making it 4 or 5 times slower)
- With MySQL - INNODB, you don't get errors either, but it was much slower than either MySQL-MyISAM or Postgres.
If anyone else is interested in finding out what i did.
To migrate from mssql to mysql.
I downloaded and installed the MYSQL migration agent, on the w2k3 server
i created and installed a new moodle server on my new squeaky clean linux box.
I only added the admin user on the moodle server. no other users.
I also installed the MySQL query browser and administrator onto the linux box
I gave the ip and user of the w2k3 machine access to the new mysql database.
I inputted my MSSQL and MYSQL server details, and I ran the migration program on the w2k3 server,
Whilst running it i had the opportunity of renaming the database moodle instead of moodle.dbo.
I then copied the moodledata folder from the w2k3 server to the linux box, and voila..
Granted i have simplified a few of the steps, and i did have to fiddle with a few ownership issues on a few files and folders, but i think a linux novice should be able to determine what to do.
for database i just use a good script to dump the data
we use like dump the sctruture of the database then the raw data
we use too SQLyog a good tool for mysql manupulation
well and the moodledata we just use winscp and paste it in the linux moodledata folder (redoing the permissions and suff)
no big deal at all we just move from windows 2003 Server Enterprise x64 to Red Hat Enterprise Linux x64
and man i'ts huge the difference and reability of the server.
If you like i can send the dump scripts to use an another windows based server for backup
We use't like this (Server A - moodlelinux) (Server B - Backup) (Server C - Moodlewindows)
Scripts goes on B then run to dump database from C and then take the sql files in B and put them in A restore it using "mysql -u root -p database < xxxxx.sql
it was this way for me and our server is running like a bullet (or not :D)
well good luck on your miggration o/
(sorry didn't see this post about 2005)