Msg#: 4525683 posted 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!