+ Post New Thread
Results 1 to 6 of 6
Virtual Learning Platforms Thread, Moodle database on SQL Server in Technical; Hi, We have Moodle installed with its database setup on a SQL Server, is it possible to move this database ...
  1. #1

    Join Date
    Feb 2010
    Posts
    34
    Thank Post
    5
    Thanked 3 Times in 3 Posts
    Rep Power
    10

    Moodle database on SQL Server

    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

  2. #2

    Hightower's Avatar
    Join Date
    Jun 2008
    Location
    Cloud 9
    Posts
    4,920
    Thank Post
    494
    Thanked 690 Times in 444 Posts
    Rep Power
    241
    Quote Originally Posted by Paul_Fielder View Post
    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

  3. Thanks to Hightower from:

    Paul_Fielder (11th March 2010)

  4. #3
    danbuntu's Avatar
    Join Date
    Dec 2009
    Location
    Maidstone, Kent
    Posts
    290
    Thank Post
    0
    Thanked 53 Times in 50 Posts
    Rep Power
    19
    you could move it onto sql express which is the free for use version of MS SQL

  5. #4

    Join Date
    Mar 2010
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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!!

  6. #5

    Join Date
    Feb 2010
    Posts
    34
    Thank Post
    5
    Thanked 3 Times in 3 Posts
    Rep Power
    10
    Quote Originally Posted by danbuntu View Post
    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.

  7. #6

    Join Date
    Feb 2010
    Posts
    34
    Thank Post
    5
    Thanked 3 Times in 3 Posts
    Rep Power
    10
    Quote Originally Posted by nave View Post
    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

SHARE:
+ Post New Thread

Similar Threads

  1. Moodle / Server 2008 / IIS7 / MS SQL Server 2008 Express
    By Kamran7860 in forum Virtual Learning Platforms
    Replies: 3
    Last Post: 23rd November 2010, 06:03 AM
  2. MS SQL server database permissions and users
    By localzuk in forum Windows Server 2000/2003
    Replies: 0
    Last Post: 30th September 2009, 10:40 AM
  3. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 08:17 AM
  4. Moodle & SQL Server 2005
    By ahunter in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 31st October 2008, 12:19 PM
  5. Backing up SQL database ?
    By Kyle in forum Windows
    Replies: 4
    Last Post: 8th June 2006, 09:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •