Lost connection to MySQL server during query

[yratof]

Please fill out the detail below, it helps me investigate the bug:

1. Driver (Ex: PostgreSQL 10.0): mysql_intel 8.0.27

2. DBngin build number: 71

3. macOS version: 14.3.1 (23D60)

4. The steps to reproduce this issue: Import a massive database file.

I can't seem to increase the allowed memory to import a large database. My file contains many fields that are just large, rather than the databse being large in content, it contains 10 fields that are huge.

this is out of the box, nothing custom set up. Couldn't find any my.cnf anywhere, can't seem to solve

[huyphams]

Hi @yratof you must create the my.cnf yourself, there is no file my.cnf by default and then set the path in the edit/create popup.

[yratof]

Right, but if I create a blank file, nothing connects. What is the default that dbngin sets if I have to overwrite everything

…

On Tue, 25 Jun 2024 at 16:44, Henry Pham ***@***.***> wrote: Hi @yratof <https://github.com/yratof> you must create the my.cnf yourself, there is no file my.cnf by default and then set the path in the edit/create popup. — Reply to this email directly, view it on GitHub <#149 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAHUTT5ZF5VGNIK522BQQJTZJF65BAVCNFSM6AAAAABJ3PBN26VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCOBZGE2TQMZQGE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[huyphams]

Right, but if I create a blank file, nothing connects.

I think MySQL Server does not like a blank file, so you may want to check the MySQL Document or some blog post

https://linuxblog.io/mysql-8-sample-config-tuning/#:~:text=The%20MySQL%20configuration%20file%2C%20also,edited%20with%20a%20text%20editor.

What is the default that dbngin sets if I have to overwrite everything

Nothing, it is the MySQL Server default.