[Bug 573318] Re: mysql server will not start

[hegemon _8]

I've fixed this issue for my case. I have kubuntu 12.04 (64-bit) and
tried to install airtime. And it was failing. As I'm newbie I've spent
few hours searching for a cause. in log file i found this:

createdb: database creation failed: ERROR:  new encoding (UTF8) is
incompatible with the encoding of the template database (SQL_ASCII)

HINT:  Use the same encoding as in the template database, or use
template0 as template.

Next two hours looking for a right solution (of many I've found), and
thanks to this:

http://askubuntu.com/questions/20880/how-do-i-create-a-unicode-databases-in-postgresql-8-4
Ive entered in terminal:
sudo pg_dropcluster --stop 9.1 main
sudo pg_createcluster --locale=en_US.utf8 --start 9.1 main

And works fine 4 me :)

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/573318

Title:
  mysql server will not start

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/573318/+subscriptions