Mysql error when importing database to a remote server

Databases
1

I built a joomla site on my local computer on Wamp server wchich is using MySQL 5.1.36.
I got the error message below when importing the database to a remote server which is using MySQL 4.0.27

" Structure of table jos_advertising

CREATE TABLE jos_advertising (
id int( 11 ) NOT NULL AUTO_INCREMENT ,
src varchar( 500 ) NOT NULL ,
link varchar( 500 ) NOT NULL ,
begins date NOT NULL ,
expires date NOT NULL ,
caption varchar( 500 ) NOT NULL ,
height int( 4 ) DEFAULT NULL ,
width int( 4 ) DEFAULT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM AUTO_INCREMENT =2;

MySQL has replied:Documentation
#1074 - Too big column length for column ‘src’ (max = 255). Use BLOB instead "

Can anyone please tell me how to export a mysql 5.1.36 database to old version?

Thank you in advance.

2

i’m afraid there is no solution other than going through what you’re going through and fixing each error like this as it comes up

either that, or design your tables with 4.0 in mind in the first place

oh, and you’d better not have any queries that use subqueries, either

3

Thank you for your quick reply. I need to rebuid the site from scratch but it’s very difficult to get Wamp or Xamp server with MySQL 4.0.27.