Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

Help with import MYSQL and Moodle

9:01 pm on Dec 6, 2012 (gmt 0)

Junior Member

joined:Oct 19, 2011
posts: 166
votes: 1

Here is the situation I am in, I trust that one of you gurus can aid me in my hour of distress.
I have moodle installed for a client, but when it was originally installed, they used version 1.9 not the 2.2.1 that's on the cpanal fantastico. As it turns out the environment is unfamiliar to my client and one of the videos doesn't work.

The problem comes, if I do another quick install back to the 1.9 version, will I have to restore the database as well or will it still be compatible after the upgrade?

In the possible preparation for that I created a new database and tried to import the sql dump I made, but there are some unfamiliar parameters:
Partial import is checked, should it be unchecked?
Format: sql
any compatibility mode?
do not use AUTO_INCREMENT for zero values is checked, should be unchecked?

Finally, I tried to import with the default settings and it said there were a number of queries that were not imported. Will that affect the data in the database? If I use it, will anything be lost?
I still a bit of a newb, so please go step by step with me.
1:27 pm on Dec 7, 2012 (gmt 0)


WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
votes: 1

Whenever I do a Moodle upgrade I set up a test environment and stage it on through. The Moodle docs are very helpful here, too. Here is the upgrading FAQ from the latest release: