Hello, myclients are facing an sql error Row Size Too Large while importing an sql file in phpmyadmin or via backup wizard.
here is my /etc/my.cnf :
please tell me how can i increase mysql roz file limit ? i am running mariadb 10.3 with mysql governor and cloudlinux.
i read all forums and all threads but didn't found an accurate or an final solution.
please tell me any final and accurate solution
here is my /etc/my.cnf :
Code:
[mysqld]
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
symbolic-links = 0
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit=80000
innodb_file_per_table = 1
innodb_log_file_size = 512M
i read all forums and all threads but didn't found an accurate or an final solution.
please tell me any final and accurate solution