Hi guys, i am using ubuntu 20.04 and ispconfig3 and mariadb according to the perfect server automatic installation for ubuntu while using the migration tool i get the information your max_allowed_packet is 16 MB DB import might fail. i want to change that in the mysql conf but i dont know where exactly to change that. /etc/mysql/mariadb.conf.d is not the right place. Can you give me a help which file i have to change ? thanks a lot for your kind help
From a Ubuntu 20.04 workstation: Code: # grep -R max_allowed_packet /etc/mysql/ /etc/mysql/conf.d/mysqldump.cnf:max_allowed_packet = 16M Looks like that is set only for the mysqldump section, you could add it under most any of the standard config files or create your own under mariadb.conf.d, just make sure it's under the correct section (which appears to be "server" for mariadb, rather than "mysqld" for mysql, though I expect the latter would work as well). Code: # head -9 /etc/mysql/mariadb.cnf # The MariaDB configuration file # # The MariaDB/MySQL tools read configuration files in the following order: # 1. "/etc/mysql/mariadb.cnf" (this file) to set global defaults, # 2. "/etc/mysql/conf.d/*.cnf" to set global options. # 3. "/etc/mysql/mariadb.conf.d/*.cnf" to set MariaDB-only options. # 4. "~/.my.cnf" to set user-specific options. # # If the same option is defined multiple times, the last one will apply.
