Moodle MySQL and Login problem

Posted on 2011-10-13
Medium Priority
Last Modified: 2012-05-12
We have a rather strange and urgent problem with moodle CMS and mysql since moving from one host to another.

Moodle works normally for guests and you can log into the front page as an admin but the moment we try to navigate we get logged out. In addition the moment you click turn editing on you immediately get logged out.

If we rebuild the site using the moodle installer all works fine (The installer creates a new database in INNODB utf8_unicode_ci.  but the moment we try to restore our database it all goes belly up again.

When we look at the database structure phpmyadmin the restored database is in MyISAM  format and Utf8_general_ci which i presume is the route of our problem.

We have tried converted the table structures to INNODB by exporting g the database and changing in notepad and reimporting (dropping the original database) but still no joy.  

Short of editing the collation setting for each table is there a quick way of changing the collation setting for all tables.

Or am i up the wrong tree altogether, any other suggestions?

Moodle 2.03
Question by:nazateam
LVL 24

Accepted Solution

johanntagle earned 1500 total points
ID: 36965776
Strange indeed.  I assume moodle versions in old and new hosts are identical.  Can you try importing the backup to another database then copying the data over to the fresh moodle install?  Something like:

Delete from freshdb.table1:
Insert into freshdb.table1 select * from olddb.table1;

I know there will be a lot of tables, but maybe you can create a script using the output of SHOW TABLES.

Author Closing Comment

ID: 36972901
Thanks for the help, kinda told me what i was expecting.

Oh well that what happens when you get someone else to migrate a website for you. so wish i had done it myself now!.


Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month17 days, 9 hours left to enroll

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question