Mysql 3.23 upgrade error | Old Forum | Forum Archive

Hi
I have a sql dump produced by joomlacloner from Mysql 3.23 in preparation for upgrading to 4.1 on the new server.

However, I get an error message below. I have tried all day to fix it.

I don't have access to the original website anymore so I can't go back and produce a more compatible dump.

So I installed the old version of mysql 3.23 with phpmyadmin 2.2.5 on my PC but I am still getting an error message.

Can anybody please suggest a solution?
thank you
Michael

[b]Error message when using mysql 4.1[/b]

SQL query:

-- MySQL dump 8.23
--
-- Host: localhost Database: joom
------------------------------------------------------- --
-- Server version 3.23.58
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS jos_banner;

MySQL said: Documentation
#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 '---------------------------------------------------------
-- Server version 3.23' at line 1

[b]Error from using mysql 3.23/ phpmyadmin 2.25[/b]

SQL-query :

DROP TABLE IF EXISTS jos_banner

MySQL said:

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 ' (no more information given)

[b]This is the first lines of sql dump which I am trying to import:[/b]
-- MySQL dump 8.23
--
-- Host: localhost Database: joom
---------------------------------------------------------
-- Server version 3.23.58

--
-- Table structure for table `jos_banner`
--

DROP TABLE IF EXISTS jos_banner;
CREATE TABLE jos_banner (
bid int(11) NOT NULL auto_increment,
cid int(11) NOT NULL default '0',
type varchar(10) NOT NULL default 'banner',
name varchar(50) NOT NULL default '',
imptotal int(11) NOT NULL default '0',
impmade int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
imageurl varchar(100) NOT NULL default '',
clickurl varchar(200) NOT NULL default '',
date datetime default NULL,
showBanner tinyint(1) NOT NULL default '0',
checked_out tinyint(1) NOT NULL default '0',
checked_out_time datetime NOT NULL default '0000-00-00 00:00:00',
editor varchar(50) default NULL,
custombannercode text,
PRIMARY KEY (bid),
KEY viewbanner (showBanner)
) TYPE=MyISAM;

--
-- Dumping data for table `jos_banner`
--

INSERT INTO jos_banner VALUES (1,1,'banner','OSM 1',0,176,0,'osmbanner1.png','http://www.opensourcematters.org','2004-07-07 15:31:29',0,0,'0000-00-00 00:00:00',NULL,NULL);
INSERT INTO jos_banner VALUES (2,1,'banner','OSM 2',0,190,0,'osmbanner2.png','http://www.opensourcematters.org','2004-07-07 15:31:29',0,0,'0000-00-00 00:00:00',NULL,NULL);
INSERT INTO jos_banner VALUES (6,2,'','herbmontage',0,1093,25,'herbmontage.jpg','www.herbresearch.com.au','2006-01-12 14:46:47',0,0,'0000-00-00 00:00:00','','');

--
-- Table structure for table `jos_bannerclient`
--

DROP TABLE IF EXISTS jos_bannerclient;
CREATE TABLE jos_bannerclient (
cid int(11) NOT NULL auto_increment,
name varchar(60) NOT NULL default '',
contact varchar(60) NOT NULL default '',
email varchar(60) NOT NULL default '',
extrainfo text NOT NULL,
checked_out tinyint(1) NOT NULL default '0',
checked_out_time time default NULL,
editor varchar(50) default NULL,
PRIMARY KEY (cid)
) TYPE=MyISAM;

--
-- Dumping data for table `jos_bannerclient`
--