MySQL install problem

Worker Joined: Apr 30, 2005 Posts: 170

I'm trying to upload my MySQL stuff using phpmyadmin. I'm getting the following error:

Code:

SQL-query:





# phpMyAdmin MySQL-Dump


# version 2.3.1-rc1


# http://www.phpmyadmin.net/ (download page)


#


# servidor: localhost


# Tiempo de generación: 08-05-2005 a las 20:26:29


# Versión del servidor: 4.01.10


# Versión de PHP: 5.0.3


# Base de datos : `nuke`


# --------------------------------------------------------


#


# Estructura de tabla para la tabla `nuke_authors`


#


CREATE TABLE nuke_authors(


aid varchar( 25 ) NOT NULL default  '',


name varchar( 50 ) default NULL ,


url varchar( 255 ) NOT NULL default  '',


email varchar( 255 ) NOT NULL default  '',


pwd varchar( 40 ) default NULL ,


counter int( 11 ) NOT NULL default  '0',


radminsuper tinyint( 1 ) NOT NULL default  '1',


admlanguage varchar( 30 ) NOT NULL default  '',


PRIMARY KEY ( aid ) ,


KEY aid( aid )


) ENGINE = MYISAM





MySQL said: 





#1064 - You have an error in your SQL syntax near 'ENGINE=MyISAM' at line 27

This is especially odd considering I performed the same upload really recently without any problems.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Try changing ENGINE = MYISAM to TYPE=MyISAM;

Posted: Fri Sep 02, 2005 3:30 am

Well I'll be. It worked.. How come I've never had that problem before? I've uploaded the same stuff a million times.

Thanks Raven..

Posted: Fri Sep 02, 2005 3:33 am

Well, it was either Engine -> Type or the ; at the end. Try engine=myisam; (add the colon)

Posted: Fri Sep 02, 2005 3:37 am

It's all fixed... Your first suggestion worked.. Another site is on the go.. Smile

Posted: Fri Sep 02, 2005 3:41 am

Posted: Fri Sep 02, 2005 3:42 am

hahaha.. You can say that again..