unable to create db

Asked by Robert Cotton on 2011-04-08

When I attempt to import or run the query I get the following. I installed xampp

Error
SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 06, 2006 at 07:25 AM
-- Server version: 4.0.24
-- PHP Version: 4.3.10-16
--
-- Database: `citrus`
--
-- --------------------------------------------------------
--
-- Table structure for table `batch`
--
CREATE TABLE `batch` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY ( `id` ) ) TYPE = MYISAM AUTO_INCREMENT =1;

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=1' at line 22

Question information

Language:
English Edit question
Status:
Solved
For:
citrusdb Edit question
Assignee:
No assignee Edit question
Solved by:
Paul Yasi
Solved:
2011-04-09
Last query:
2011-04-09
Last reply:
2011-04-09
Robert Cotton (cotton-robert) said : #1

Apache/2.2.17
Server version: 5.5.8
 PHP/5.3.4

Best Paul Yasi (paul-citrusdb) said : #2

It looks like newer versions of MySQL have deprecated the TYPE keyword in favor of the ENGINE keyword. I've updated the sql file for testing. You can download it from the source repository here:

http://bazaar.launchpad.net/~paul-citrusdb/citrusdb/gpg/view/head:/citrus.sql

Robert Cotton (cotton-robert) said : #3

Thanks Paul Yasi, that solved my question.