October 30, 2013 at 10:52 am #13095
“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?
October 30, 2013 at 11:11 am #34619
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.
October 30, 2013 at 11:14 am #34620
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?
October 30, 2013 at 11:43 am #34621
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.
October 30, 2013 at 12:09 pm #34622
thanks for your response, Option 1 makes more sense now.
I'm not seeing anything 'Option 2' ish when I follow your instructions…
October 30, 2013 at 12:59 pm #34623
You can find this in Powertools-> Import External data.
October 30, 2013 at 1:30 pm #34624
.. or as I wrote in the database menu/context menu when a database is selected in Object Browser.
October 30, 2013 at 1:31 pm #34625Quote:Note: This feature is available in SQLyog Enterprise and Ultimate.
I'm only a professional account user.
November 4, 2013 at 9:12 am #34626
If you are considering upgrading, please contact firstname.lastname@example.org. 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.