Solved

How to convert a mysql database to utf-8

Posted on 2010-11-10
5
630 Views
Last Modified: 2013-12-12
I have a dump file of my Moodle 1.8 instance. The instance was on a server that is now physically dead. I am trying to move it to a Moodle 1.9 server, but when I attempt to upgrade, I get a message stating that all my tables have to be in UTF-8 before proceeding. How can I convert the entire dump file to UTF-8?
0
Comment
Question by:smetterd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 13

Expert Comment

by:dsmile
ID: 34101979
If you mean you have to convert that dump file to UTF-8 encoding to use with Moodle upgrading process, then it means you need to convert a text file to UTF-8 encoding. If that's really the case, then use some UTF-8 supporting text editor like EmEditor or Edit Plus (both are available in trial version) to open that dump file and save it as UTF-8 encoding.

If your case is that you import that dump file to a new DB, but it isn't UTF-8 encoding yet, then you can import again with this command

mysql -h host -u username -p password --default_character_set utf8 database < your_dump_file
0
 
LVL 6

Expert Comment

by:Ferrosti
ID: 34102222
The most comfortable way would be to setup mySQL with UTF-8 as global default and restore your dump then. Make sure first that there are no commands in your dump file to create your tables in another codepage.
0
 
LVL 31

Accepted Solution

by:
Marco Gasi earned 500 total points
ID: 34105984
Use this

ALTER TABLE table1
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci;

Change last row accordingly your needs

Cheers
0
 
LVL 2

Author Comment

by:smetterd
ID: 34113722
Is this allowable?

ALTER DATABASE database1
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci;
0
 
LVL 2

Author Closing Comment

by:smetterd
ID: 34113945
ALTER DATABASE harlinge_drcmdl
DEFAULT CHARACTER SET utf8
COLLATE utf8_general_ci;


Worked perfectly! Thank you!
0

Featured Post

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

696 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