Moodle data and backup migration to new server

[bert113]

Can anyone give me some advice..

 

We have cancelled our support with our Moodle supplier... they have sent us our database backup as a SQL file and the moodledata folder but I am struggling to work out how to import these onto a clean install of Moodle.

 

I have downloaded the latest Windows version and got a 3.1 empty version working but I have attempted and failed to import data supplied. (I believe the backup etc are from version 2.7 on a Linux server)

 

Can anyone point me in the right direction

 

Thanks in advance..

 

D

[ItsOggy]

It's been a while since I've moved a moodle install but I suspect you will need to restore the SQL file to a new db then install 2.7 and point it at the db / restore the moodledata folder and update to 3 after.

 

I would guess the db structure may be very different!

[3s-gtech]

Restore the DB to the same version on the server. With that in place, follow the Moodle docs for updating to 3 (this is much easier than 1.9-2.2).

[bencellis]

You've done the wrong way round.

 

First restore the Database - I assume it is MySQL?

Create a Moodle DB user with all rights on the database - I recommend that the user can only access from localhost e.g in MySQL -GRANT ALL on moodledb.*

TO 'moodleuser'@'localhost' IDENTIFIED BY 'password'

Next copy your moodledata folder to the web root folder - not the document root - e.g if your webserver's web root is /var/www, the document root is likely to be /var/www/html/ so moodledata will be in /var/www/moodledata. Moodle will sit in the document root.

Install Moodle and ensure that you sepecify the Moodledb, your new created database user and the correct path to the Moodledata folder.

DONE