Mysql error

Submitted by SarganSaor on 2007-12-13


dpkg -l| grep mysql-server
ii  mysql-server-5.0        5.0.45-1ubuntu3
mysql -p wi < schema-mysql41.sql
Enter password:
ERROR 1064 (42000) at line 7: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{attr_types} (
  attr_id int(11) NOT NULL auto_increment,
  type_id int(11) NOT ' at line 1

How fix it?

The *.sql files included in the setup directory are just template files. You're not supposed to run them directly. Use the setup script as described in the manual to create the database.