homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Help with import MYSQL and Moodle

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.



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

Msg#: 4525683 posted 1:27 pm on Dec 7, 2012 (gmt 0)

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:

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved