Upgrade problems

Upgrade problems

аз 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/

In reply to Tracy Gibson

Re: Upgrade problems

аз Martin Dougiamas -
Сурати  корбар Core developers Сурати  корбар Documentation writers Сурати  корбар Moodle HQ Сурати  корбар Particularly helpful Moodlers Сурати  корбар Plugin developers Сурати  корбар 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/