SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Oct 2007
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql error when importing database to a remote server

    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 repliedocumentation
    #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.
    Get Your Sites Listed In Our Search Engine
    Friendly Free Directory within 24 Hours http://gisgap.com

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,251
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by fred08 View Post
    Can anyone please tell me how to export a mysql 5.1.36 database to old version?
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Member
    Join Date
    Oct 2007
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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.
    Get Your Sites Listed In Our Search Engine
    Friendly Free Directory within 24 Hours http://gisgap.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •