I'm trying to install the DB for Drupal.

I d/l the most current version of 4.7 and I'm running into a problem when I upload my SQL file to add the tables

My version of MySQL is 4.0.27 and I am using the SQL file for "database.4.1.mysql"

I keep getting the following message everytime I import it

Error

SQL query:

-- $Id: database.4.1.mysql,v 1.1.2.4 2007/01/04 22:01:17 killes Exp $
--
-- Table structure for table 'access'
--
CREATE TABLE access(
aid int( 10 ) NOT NULL AUTO_INCREMENT ,
mask varchar( 255 ) NOT NULL default '',
TYPE varchar( 255 ) NOT NULL default '',
STATUS tinyint( 2 ) NOT NULL default '0',
PRIMARY KEY ( aid )
) DEFAULT CHARACTER SET utf8;

MySQL said: Documentation
#1064 - 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 'DEFAULT CHARACTER SET utf8' at line 8

any help would be greatly appreciated

Comments

mdixoncm’s picture

If your mysql is version 4.0.27 then you should be using the database.4.0.mysql file (the 4.0 refers to the version of mysql) ...

hopefully that should fix your problems :)

Cheers,

Mike

Like books? Check out booktribes the new (Drupal based) community for book lovers
from Computerminds

RickyG’s picture

yea...i feel stupid now

thanks

mdixoncm’s picture