[horde] Newbie doing initial horde installation

[Vilius Šumskas]

Hello Eric,

Thursday, November 2, 2006, 7:03:24 PM, you wrote:

> bash-2.05b$ mysql -u root < create.mysql.sql
> ERROR 1064 at line 154: You have an error in your SQL syntax near 'ENGINE =
> InnoDB' at line 6
> bash-2.05b$

> I had originally set skip-innodb in /etc/my.cnf, hoping to keep it as 
> simple as possible and knowing that this database is going to see VERY
> light use (rarely more than one user at a time and never more than about
> four).  But, it appears that create.mysql.sql requires it, so I changed
> my.cnf to get rid of the skip-innodb and include:

> innodb_data_file_path=ibdata1:10M:autoextend

> mysqld seems to start up OK with that, using

> /etc/init.d/mysqld start

> ...(whereas before it would complain in the log file about the missing
> innodb_data_file_path, until I put skip-innodb in...).

> But, if I say...

> bash-2.05b$ mysqladmin -u root drop horde
> bash-2.05b$ mysql -u root < create.mysql.sql

> ... I still get the ERROR 1064.

Are you running MySQL 3.23.x by chance? In this case you need to change
ENGINE to TYPE.

-- 
Best regards,
 Vilius