[RESOLVED] Error when importing sql file into PHPMyAdmin

[cretam]

Hi,
I get this error "#1064 - You have an error in your SQL syntax near 'collate latin1_general_ci NOT NULL,
PRIMARY KEY (skills_id)
) ENGINE=InnoDB' at line 3 "
when I import my file into PHPMyAdmin.
Can someone tell me why please?
Thanks in advance.

[bradgrafelman]

Can you show us all of this table's CREATE TABLE declaration?

[cretam]

Here is the sql file:
-- phpMyAdmin SQL Dump
-- version 2.9.2

-- http://www.phpmyadmin.net

-- Host: localhost
-- Generation Time: Apr 18, 2007 at 11:11 PM
-- Server version: 5.0.33

-- PHP Version: 5.2.1

-- Database: newtammy

---

--

-- Table structure for table skills

CREATE TABLE skills (
skills_id int(5) NOT NULL auto_increment,
skills_title text collate latin1_general_ci NOT NULL,
PRIMARY KEY (skills_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table skills

---

--

-- Table structure for table skills_hierarchy

CREATE TABLE skills_hierarchy (
parent int(5) default NULL,
child int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table skills_hierarchy

---

--

-- Table structure for table training

CREATE TABLE training (
training_id int(5) NOT NULL auto_increment,
training_title text collate latin1_general_ci NOT NULL,
PRIMARY KEY (training_id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table training

---

--

-- Table structure for table training_hierarchy

CREATE TABLE training_hierarchy (
parent int(5) default NULL,
child int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--

-- Dumping data for table training_hierarchy

[NogDog]

I copied-and-pasted the portion for creating the skills table, and it ran fine for me.

What version of MySQL are you running? I tested it in 5.0.

[cretam]

All working fine now.