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

"import Csv" Is Disabled

forums forums SQLyog Using SQLyog "import Csv" Is Disabled

Tagged: ,

This topic contains 7 replies, has 0 voices, and was last updated by  peterlaursen 5 years, 2 months ago.

  • Author
    Posts
  • #13095

    garrilla
    Member

    “Import CSV data using LOAD LOCAL…” is disable on the Table>Import menu

    Load local is definitely on in the server.

    I'm using a WAMP installation if that helps.

    Any advice on how to get this enabled?

  • #34619

    sathish
    Member

    Hello,

    This is because you have not selected the table in the object browser. This option will be enabled only when you select a table in the object browser. Please find the screen shot attached for your reference.

    Regards,

    Sathish

  • #34620

    garrilla
    Member

    Ah, thank you Sathish.

    Does that mean I can't import a .csv file and use the first-line as header information to create the table?

  • #34621

    peterlaursen
    Participant

    There are 2 ways to import from CSV.

    1) Using LOAD DATA LOCAL syntax. When using this option the table must be created in advance (the LOAD DATA statement is executed by the server and does not have an option to create a table – refer http://dev.mysql.com…/load-data.html)

    2) Using ODBC (in case Microsoft text ODBC-driver). This tool (named 'Import External Data') can create the table.

    If you select a 'database node' in the Object Browser the menu/context menu for 2nd option is available.

  • #34622

    garrilla
    Member

    Hi Peter,

    thanks for your response, Option 1 makes more sense now.

    I'm not seeing anything 'Option 2' ish when I follow your instructions…

    Thanks again,

    Garry

  • #34623

    sathish
    Member

    You can find this in Powertools-> Import External data.

    Please refer: https://static.webyog.com/docs/SQLyog/Migration_Toolkit_SQLyog_MySQL_Manager.htm

  • #34624

    peterlaursen
    Participant

    .. or as I wrote in the database menu/context menu when a database is selected in Object Browser.

  • #34625

    garrilla
    Member
    Quote:
    Note: This feature is available in SQLyog Enterprise and Ultimate.

    I'm only a professional account user.

    🙁

  • #34626

    peterlaursen
    Participant

    If you are considering upgrading, please contact sales@webyog.com. You will of course not need to pay the full price for Enterprise or Ultimate as you already paid for Professional.

You must be logged in to reply to this topic.