Problem in DB Import

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • waqasmgl
    New Member
    • Nov 2007
    • 20

    Problem in DB Import

    Hi all,

    I m having trouble in importing a sql file.
    I m using MySql 5.1.36.
    Using WAMP Server Version 2
    phpMyAdmin version 3.2.0.1

    Following error was displayed by phpMyAdmin
    Code:
    #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 'U' at line 1
    
    U�S�E� �[�I�U�A�O�S�]�
    
    G�O�
    
    S�E�T� �A�N�S�I�_�N�U�L�L�S� �O�N�
    
    G�O�
    I m attaching the file also.

    PS: I m not sure what version is the sql file of and also dont know about the program. Probably MySql.
    I have tried all compatibility options available in phpMyAdmin and the error remains same.

    Edit: After checking the bak file i found that the database software was Microsoft Sql Server. Please provide directions.

    Thanx
    Attached Files
    Last edited by waqasmgl; Aug 18 '10, 07:52 PM. Reason: Edit Heading
  • Oralloy
    Recognized Expert Contributor
    • Jun 2010
    • 988

    #2
    @waqasmql,

    You have a sticky wicket.

    I don't know if MySQL has any tools for importing SQL formatted in uSoft's lovely non-standard format.

    Perhaps there's a third party conversion program?

    If you're only interested in importing the table structure, you should be able to do a relatively quick hand translation of that mess. [Then hoist a scotch and say relive the memories of the pain forever.]

    I didn't see any INSERTS in the file, so I assume that there are no data to translate. That's a good thing.

    As for the display forms, they're going to be lost to you, unless you find a third party translator that builds something useful from them.

    Hopefully that helps a little.

    Comment

    • waqasmgl
      New Member
      • Nov 2007
      • 20

      #3
      Thanx Oralloy for your kind reply.

      Comment

      Working...