Shape5

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!

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!

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