Hi all, I had a major problem with my Moodle server yesterday and unfortuantley had to reinstall so I have the new server up and running with Xampp etc and have copied all my old files. But when I try to reinstall Moodle I get the UTF-8 error saying my database needs to be converted. I thought I had already done this but it appears not. I have looked on here for some help files and was told to convert my Flat file to UTF-8 which I did and still got the same error, does anyone have an easy quick way for me to convert to UTF-8 please?
This is the process I used (fill in your own values for YourUserName, YourDatabaseServer, YourMoodleDatabaseName and SomeDumpFileName.dump )
- Backup mysql database:
- mysqldump -uYourUserName -p -hYourDatabaseServer YourMoodleDatabaseName >SomeDumpFileName.dump
- mysql -uYourUserName -p -hYourDatabaseServer YourMoodleDatabaseName
- alter database character set = 'utf8' collate='utf8_general_ci';