Formatting of Views

[expired user #6764]'s profile image [expired user #6764] posted 8 years ago in General Permalink

I believe this is maybe a MySQL issue but am hoping you may be able to suggest a solution.

After upgrading to 5.6.29 when we save a database view in Heidi we lose any formatting that is entered in the editor window, when we look at the view a second time it will be on one line, and tabel and column names are all decorated with ``

Any suggestions on how we can turn this feature off appreciated

Thanks

Finbar

rasmush's profile image rasmush posted 8 years ago Permalink

If this is because MySQL does not store the original format, then maybe simply format the statements in some way a little prettier than what MySQL throws back.

[expired user #6764]'s profile image [expired user #6764] posted 8 years ago Permalink

Hi I was wondering if anyone else was having this problem, as I don' believe I was until I upgraded to 5.6

rasmush's profile image rasmush posted 8 years ago Permalink

I see the same using MySQL 5.1

[expired user #6764]'s profile image [expired user #6764] posted 8 years ago Permalink

I found the solution to this so just posting in case it helps others.

My 5.5 MYSQL worked as expected with HeidiSQL, my 5.6.29 was "loing the format", turns out that the LOAD_FILE function was returning NULL when on 5.6, because of a configuration option

secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.6/Uploads"

I set this to

secure-file-priv=""

Restarted and it works perfectly

Please login to leave a reply, or register at first.