fred08 — 2010-04-29T08:38:19-04:00 — #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
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 (
) 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.
r937 — 2010-04-29T08:58:31-04:00 — #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
fred08 — 2010-04-29T09:12:30-04:00 — #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.