problems importing a database into mysql

[Ovidiu]

h898552:/var/www# mysql -h localhost -u root -p****** web3_db1 < web3_db1.sql
ERROR 1064 at line 12: 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 'NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM'
h898552:/var/www#

trying to export a db from one server and import on another. both servers are debian 3.1 and running MySQL version 4.0.24

[Ben]

Could you show this last block from the dump (the last line ending with "NOT NULL")?

[Ovidiu]

here is the sql dump right from the start:

I just realized this part only concerns one plugin, which I could easily take out from my dump, I will try without that part.

-- MySQL dump 9.11
--
-- Host: localhost Database: web3_db1
-- ------------------------------------------------------
-- Server version 4.0.24_Debian-10sarge2-log

--
-- Table structure for table `bad_behavior`
--

DROP TABLE IF EXISTS bad_behavior;
CREATE TABLE bad_behavior (
id int(11) NOT NULL auto_increment,
ip text NOT NULL,
date datetime NOT NULL default '0000-00-00 00:00:00',
request_method text NOT NULL,
request_uri text NOT NULL,
server_protocol text NOT NULL,
http_headers text NOT NULL,
request_entity text NOT NULL,
key text NOT NULL,
PRIMARY KEY (id),
KEY ip (ip(15))
) TYPE=MyISAM;

--

[Ben]

the old problem, when using reserved words in column names, and thei are not wrapped ind ` (backtick) as the normal mySQL Syntax is.... good example for that when germans design their tables is "alter"...

So just change

key text NOT NULL

to

`key` text NOT NULL

[Ovidiu]

thx for analyzing the problem, I have no clue about mysql, this whole structure is wordpress (a plugin for it created that problem :-)

I seem to have succeeded by deleting that old plugin and its tables and all of its data that it created inside the DB.