Good day! It is necessary to export the mysql 5.7.20 database with large BLOB-fields. Naturally, you need to increase max_allowed_packet. I try to export through Workbench 6.3. So, the value of the max_allowed_packet variable changes only in the [mysqld] section. Break the Internet, I learned that I need to change both on the client and on the server. But the Workbench in other sections does not change (that is, changes, but is not remembered - I move from one section to another, for example, from [mysql] to [mysqld] and the value in [mysql] is reset to default). In my.ini, I wrote my max_allowed_packet values ​​in different sections of [mysql] [mysqld] [mysqldump]. But there is no result. Changed values ​​are still seen only in [mysqld]. I tried through the command line, but nothing happens there at all. An arrow appears -> and that's it. By the way, what does it mean?

enter image description here

enter image description here

enter image description here

enter image description here

  • max_allowed_packed or max_allowed_packet ? - Raz Galstyan
  • And what does the line mean -> and everything? Maybe attach a picture to the question? And tell me exactly what you are doing on the command line? - Raz Galstyan
  • I know that is not relevant. Probably you have DT_IMAGE in portable data - Alexandr Fatalny

0