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
Check the file you are using
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
Mike,
Computerminds offer Drupal development, consulting and training
wow
yea...i feel stupid now
thanks
don't worry ...
... I feel stupid most of the time :)
Like books? Check out booktribes the new (Drupal based) community for book lovers
from Computerminds
Mike,
Computerminds offer Drupal development, consulting and training