Re: MySQL Workbench query results export
> 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.
Subject
Views
Written By
Posted
1210
November 25, 2021 09:10AM
437
November 25, 2021 09:11AM
Re: MySQL Workbench query results export
463
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.