Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 687
  • Last Modified:

Trying to import mysql file via phpmyadmin. Error message

Hello Mysql experts.

I'm trying to import a file into a mysql database using phpmyadmin.

Here's the first error I get.  Hopefully fixing it will let me import the complete file.

Error
SQL query:

CREATE TABLE  `#__ak_profiles` (

`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`description` VARCHAR( 255 ) NOT NULL ,
`configuration` LONGTEXT,
`filters` LONGTEXT,
PRIMARY KEY (  `id` )
) TYPE = MYISAM AUTO_INCREMENT =2;

MySQL said: 

#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 'TYPE=MyISAM AUTO_INCREMENT=2' at line 1 

Open in new window

That's the error. If you need a snippet from the sql text file, let me know.

Here's some info regarding the version of mysql etc.

Server: Localhost via UNIX socket
Server version: 5.5.23-55
Protocol version: 10
User: chiropra@localhost
MySQL charset: UTF-8 Unicode (utf8)

cpsrvd 11.34.1.16
MySQL client version: 5.5.23
PHP extension: mysql

Thanks!

Rowby
0
Rowby Goren
Asked:
Rowby Goren
1 Solution
 
johanntagleCommented:
it should be ENGINE=MYISAM, not TYPE
0
 
Rowby GorenAuthor Commented:
Thanks!

Your solution fixed a big headache!

Rowby
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now