Moodle database on SQL Server

[Paul_Fielder]

Hi,

 

We have Moodle installed with its database setup on a SQL Server, is it possible to move this database across in with the data intact into a MySQL database.

I have tried exporting with EMS MsManager however, the file size is 109 MB, the limit for an import into PHPmyAdmin is 2 MB.

 

We understand that we may have to hand edit some of the table creation SQL, but just wondered if there is a cheap (FREE) alternative anyone could recommend.

 

Paul

[Hightower]

PHPmyAdmin is 2 MB.

 

You can increase this by editing your INI files and restarting the service. Should be able to put it as big as you need

[danbuntu]

you could move it onto sql express which is the free for use version of MS SQL

[nave]

I suggest you import in shell. It is fast and efficient.

 

#mysql mdldatabase < db-dump-mdl.sql

 

Alternatively you can increase the import size in /etc/php.ini and work from phpmyadmin

 

All the Best!!

[Paul_Fielder]

you could move it onto sql express which is the free for use version of MS SQL

 

We need to get it back into MySQL so that its is easy to update patch and add plugins, so MySQL is the natural route. Thanks for your comment.

[Paul_Fielder]

I suggest you import in shell. It is fast and efficient.

 

#mysql mdldatabase < db-dump-mdl.sql

 

Alternatively you can increase the import size in /etc/php.ini and work from phpmyadmin

 

All the Best!!

 

We also discovered this late this afternoon, obviously it fails due to the Sql / MySQL code differences but I will have a stab at making the changers on all 80,000 lines of code when we get the time.

I’m hoping that a find and replace may get us by.

 

Thanks

 

Paul