SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Dec 2008
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Import error because of delimiter messing

    Once upon a time
    I have saved a backup of mySQL database.

    The text fields may include the HEX27 symbol inside the utf8 coding.

    The same symbol HEX27 is used as the delimiter between the fields.

    In result:
    Quote Originally Posted by Import
    #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 ' ...
    How can I change the delimiter in the .sql file ?
    It is 37Mb size.

  2. #2
    SitePoint Zealot j3ph's Avatar
    Join Date
    Jan 2006
    Posts
    134
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'd look into the sed command (if you are using a unix based OS:
    http://linux.about.com/od/commands/l/blcmdl1_sed.htm

  3. #3
    SitePoint Member
    Join Date
    Dec 2008
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was wrong in my initial problem formulation.

    I should have said:

    ~Import error because of delimiter
    embaracing symbol messing~

    And then:
    ~The same symbol HEX27 is used as the delimiter between the fields
    embaracing symbol for text fields.~

    And then:
    ~How can I change the delimiter
    embaracing symbol for text fields in the .sql file ?~


    But the forum does not allow to edit own posts
    since any period.

    Does anybody know human forums
    with own posts editing time unlimited
    and gritoadmixes provided ?

  4. #4
    SitePoint Wizard guelphdad's Avatar
    Join Date
    Oct 2003
    Location
    St. Catharines, ON Canada
    Posts
    1,707
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    most forums do not let you edit posts, or post links until you have met a minimum number of posts or been a member past a certain time (like 10 posts or 30 days).


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
  •