Good afternoon,
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?
Thanks
Darin Bawden
Windows 2000 Server migration to Linux
Number of replies: 11Re: Windows 2000 Server migration to Linux
You won't regret this "contemplation" 
The simplest migration IMHO is to export the present courses and to import them in the new server.
The simplest migration IMHO is to export the present courses and to import them in the new server.
Re: Windows 2000 Server migration to Linux
I kjnow this'll be another bone-headed question, but does moodle have an "export" feature?
::::::ducking for cover::::::
Darin
::::::ducking for cover::::::
Darin
Re: Windows 2000 Server migration to Linux
Depends on your definition of export. What are you looking to export, where to
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.)
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.)
Re: Windows 2000 Server migration to Linux
The usual Moodle export business is done by dumping the database in SQL as someone else explained.
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
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
Re: Windows 2000 Server migration to Linux
Darin,
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
2. In the Windows mySQL administration (I use PHPMyAdmin), export the moodle database.
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.
Bob
Windows 2003 Server migration to Linux
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.
Re: Windows 2003 Server migration to Linux
One of the new features in Moodle 2.0 is a database transfer script that will copy everything from one database to another.
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
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
Re: Windows 2003 Server migration to Linux
What did you decide with the MySQL and Postgres comparison?
Re: Windows 2003 Server migration to Linux
Testing is still going on. We have found a weird performance issue with postgres where the first time time you run the script that has 300 people log in and make a forum post it takes about 120 seconds, and after a few runs, that climbs to 700 seconds. And this is starting with a copy of the Moodle.org database, so there are thousands of posts in the DB to start with, so an extra few hundred should not make that much difference.
But to summarise one thing we have found so far:
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.
Re: Windows 2003 Server migration to Linux
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.
Re: Windows 2000 Server migration to Linux
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)