MySQL Forums
Forum List  »  MySQL Workbench

Re: How to import CSV onto AWS MySQL?
Posted by: Ken Dulin
Date: January 20, 2015 01:46PM

I do this outside of MySQL Workbench. I transfer the file to the remote server and then use LOAD DATA LOCAL INFILE from the terminal.

See http://dev.mysql.com/doc/refman/5.5/en/load-data.html for more information on this.

If you are using Ubuntu you may have to adjust the AppArmor config depending on where you saved the csv file.

Options: ReplyQuote


Subject
Views
Written By
Posted
3622
January 12, 2015 02:08AM
1233
January 12, 2015 02:46PM
1318
January 13, 2015 02:16AM
Re: How to import CSV onto AWS MySQL?
820
January 20, 2015 01:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.