SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Evangelist j0n's Avatar
    Join Date
    Apr 2003
    Location
    uk
    Posts
    545
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Collations in pre-4.1 versions (was "MySQL help desperately needed, Probally very sim

    I have a site that runs off a mysql database. I need to use this database on another website.

    I have loged into phpmyadmin, clicked on "export". Then saved the database as a file.

    I then login to phpmyadmin on the new site that i want to use the database with. I click on "SQL" and then upload the file.

    This is the error message that i am getting.

    Code:
    #1064 - You have an error in your SQL syntax near 'collate latin1_general_ci NOT NULL default '',
      `cOrder` bigint(20) NOT NULL de' at line 21
    Am i downloading the database wrong? This is very confusing.

    Any help is GREATLY appreciated.

    Thanks in advanced,
    Jon

  2. #2
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    It seems like the first server has MySQL >= 4.1, and the other one MySQL < 4.1. You can't use collations in versions prior to 4.1, so you'll have to modify all the CREATE TABLE queries and remove all collation-related options.
    ERIK RIKLUND :: Yes, I've been gone quite a while.

  3. #3
    SitePoint Evangelist j0n's Avatar
    Join Date
    Apr 2003
    Location
    uk
    Posts
    545
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply.

    Is there anything i can do about this?

  4. #4
    Tranceoholic lilleman's Avatar
    Join Date
    Feb 2004
    Location
    Írebro, Sweden
    Posts
    2,716
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I just edited my post, didn't see your new post until now.
    ERIK RIKLUND :: Yes, I've been gone quite a while.

  5. #5
    SitePoint Evangelist j0n's Avatar
    Join Date
    Apr 2003
    Location
    uk
    Posts
    545
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the reply. I have sent you a PM.


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
  •