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

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

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.