Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Text File Import Problem : Bad Name?

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Text File Import Problem : Bad Name?

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 18, 2006 at 9:59 pm #9975
      Paula
      Member

      Hello. I am brand new to SQLyog – and rather new to MySQL as well. I'm trying to import some .txt and .csv files. I'm using the migration toolkit and the odbc text drivers. I keep getting this error message after I've selected my tables for import:

      SQLyog Job Agent Version 5.18

      Copyright © Webyog Softworks Pvt. Ltd.. All Rights Reserved.

      Job started at Wed Oct 18 16:36:48 2006

      DBMS Information: TEXT

      Importing table schema: brthdate.txt…

      ERROR: 1103, Incorrect table name 'brthdate.txt'

      Table:brthdate.txt

      Sql:select * from `brthdate.txt` where 1=0

      Check C:Documents and SettingsplavigneMy DocumentsDataFilesDPSDPS-JOINfiles.xml for complete error details.

      ERROR: 1103, Incorrect table name 'brthdate.txt'

      Table:brthdate.txt

      Sql:DROP TABLE IF EXISTS `dps-usps`.`brthdate.txt`

      Check C:Documents and SettingsplavigneMy DocumentsDataFilesDPS_ConvictDPS-USPS-JOINfiles.xml for complete error details.

      Importing table schema: nam.txt…

      …etc…

      I haven't the foggiest idea what I did wrong? I've searched the forums for a similar problem, but haven't found anything. Any help would be much appreciated.

      Thank you.

      Paula

    • October 19, 2006 at 5:58 am #22805
      peterlaursen
      Participant

      The problem is that the table name 'brthdate.txt' in not valid wilt MySQL before version 5.1.

      You will have to use the mapping option to rename the table to something that is supported.

      Oracle, SQL server etc. conform to standard SQL in respect to table naming. MySQL only does from version 5.1.

    • October 24, 2006 at 2:51 pm #22806
      Paula
      Member
      peterlaursen wrote on Oct 19 2006, 12:58 AM:
      The problem is that the table name 'brthdate.txt' in not valid wilt MySQL before version 5.1.

      You will have to use the mapping option to rename the table to something that is supported.

      Oracle, SQL server etc. conform to standard SQL in respect to table naming. MySQL only does from version 5.1.

      Great, thanks!

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.