Unable to create db

[Mihai Badea]

Hi!

I'm trying to reinstall piler... something went wrong the first time :) I'm following the FAQ, dropped the piler database, but I am unable to re-create it:

#!mysql -u piler -p piler < ./util/db-mysql.sql

gives me:

#!ERROR 1071 (42000) at line 109: Specified key was too long; max key length is 1000 bytes

[eXtremeSHOK]

Database needs to be set to UTF8 ( CHARSET=utf8; ), you will get that issue if its set to latin1

[Mihai Badea]

I re-created the databse as per instructions in the FAQ:

mysql> drop database piler;

mysql> create database piler character set utf8;

The default collation is utf8_general_ci

[Janos SUTO]

How is it possible that you managed to create it earlier, but not this time? What mysql version do you use? BTW. you have to double check the script and your mysql config since you have myisam tables everywhere even though the piler SQL script defines innodb for virtually all tables.

[Mihai Badea]

Guess it didn't work the first time either :)) However, you comment about myisam and innodb put me on the right track; innodb engine was set to off. After setting it to on and restarting mysqld, the script created all the tables.