MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL Workbench query results export
Posted by: Peter Brawley
Date: November 25, 2021 12:17PM

> constrain the free-text fields so they don't get split into multiple columns

Consider posting representative examples.

> I do not have the ability to write to an OUTFILE due to my access privileges.

In my.cnf, set secure_file_priv = the exact path to your desired import/export folder, then restart MySQL.

For reasons I've never understood, MySQL on a Mac comes without my.cnf. Brainless. To create my.cnf, open a connection in WorkBench, select 'Options File' under 'Instance' in the menu; WB will look for my.cnf and if it's not found will offer to create it.

Options: ReplyQuote


Subject
Views
Written By
Posted
50
November 25, 2021 09:10AM
Re: MySQL Workbench query results export
12
November 25, 2021 12:17PM


Sorry, only registered users may post in this forum.

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.