Shape 5

I am running into a problem when trying to move my site (kite photography template) from a machine with:

 phpMyAdmin 2.6.0-pl3 & MySQL 3.23.58

to a machine with:

phpMyAdmin - 2.8.2.4 & MySQL - 5.0.27

I export the database from the existing machine, but when I import into the new machine i get the following error:
--------------------------------------
Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 25, 2008 at 06:01 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.10
--
-- Database: `iovjoomla`
--
CREATE DATABASE `iovjoomla` ;

USE iovjoomla;

-- --------------------------------------------------------
--
-- Table structure for table `jos_banner`
--
CREATE TABLE `jos_banner` (
`bid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`cid` int( 11 ) NOT NULL default '0',
`type` varchar( 90 ) NOT NULL default 'banner',
`name` text NOT NULL ,
`alias` varchar( 255 ) 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( 150 ) default NULL ,
`custombannercode` text,
`catid` int( 10 ) unsigned NOT NULL default '0',
`description` text NOT NULL ,
`sticky` tinyint( 1 ) unsigned NOT NULL default '0',
`ordering` int( 11 ) NOT NULL default '0',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`tags` text NOT NULL ,
`params` text NOT NULL ,
PRIMARY KEY ( `bid` ) ,
KEY `viewbanner` ( `showBanner` ) ,
KEY `idx_banner_catid` ( `catid` )
) TYPE = MYISAM AUTO_INCREMENT =1;

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 'bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `t' at line 1
-----------------------------------------------

I have searched and found lots of info on this but nothing I have found works -- Any help you can provide would be much appreciated!

Hi, I would contact you hosting company about this problem. The errors are showing incorrect sql syntax. All of the syntax is generate when the database is exported from your server.

Problem is that I lease the two machines - the old one is a 4 year old machine with older software -
one post via google said to use compatibility mode when importing into the new db, the php admin has no such
option - do you know anything about compatibility mode??

thanks for your quick response - as usual!

Try deleting the lines of SQL that the error is complaining about and then importing.

problem is that the lines are the ones that create the main table in the databse...