By iraszl on

I'm trying to make a local copy of my website and I'm keep getting errors when trying to load the sql file to the local database:

 SQL-query:

CREATE TABLE `access` (
`aid` tinyint( 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` )
) ENGINE = MYISAM DEFAULT CHARSET = 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 CHARSET=utf8' at line 7

So, I checked the online database with phpmyadmin and I'm getting this error:

Problems with indexes of table `node`
Warning More than one INDEX key was created for column `status`
Problems with indexes of table `term_hierarchy`
Warning PRIMARY and INDEX keys should not both be set for column `tid`
Problems with indexes of table `term_node`
Warning PRIMARY and INDEX keys should not both be set for column `tid`

Any suggestions as to what should I do about this?

⋅ Categories: Drupal 4.7.x