Upgrade problems

Upgrade problems

by Tracy Gibson -
Number of replies: 2

I upgraded from 1.0.6.2 to 1.0.8.1, but I did it without the upgrade instructions which I couldn't find. 

Everything went well, except, my previous install did not have a table prefix.  Since, I really wasn't sure what that was for, I left it in the config.php file as "mdl_"  So now, the setup created all new tables in my database with the mdl_ prefix.  Now that I have messed things up, what would be the most efficient way to reach the data in my old "unprefixed" tables.

Is the table structure the same that I could just delete the mdl_ prefixed tables and rename the old table mdl_tablename or is there a better way?

Thanks,

Tracy Gibson
http://homeschoolanswer.com/moodle/

Average of ratings: -
In reply to Tracy Gibson

Re: Upgrade problems

by Martin Dougiamas -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers
OK, you can delete/ignore all the newly created mdl_xxxxxx tables.

Go back to your old, original config.php - there is no need to change it. If you do want to add the prefix setting, make sure it is empty. ie ""

Now do the the upgrade again by visiting your admin page. The upgrade will update your existing tables, keeping all the data in there.

For future reference, instructions are here: http://moodle.org/doc/ or in http://homeschoolanswer.com/moodle/doc/
Average of ratings: -