Welcome to WebmasterWorld Guest from 54.234.63.187

Forum Moderators: open

Message Too Old, No Replies

Help with import MYSQL and Moodle

     

Gilead

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



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.
Thanks!

coopster

1:27 pm on Dec 7, 2012 (gmt 0)

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



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:
[docs.moodle.org...]
 

Featured Threads

Hot Threads This Week

Hot Threads This Month