There is not really much of configuration files.
My.cnf contains only references
mysqldump.cnf contains:
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
mysqld.cnf contains:
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
bind-address = 127.0.0.1
key_buffer_size = 16M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover-options = BACKUP
query_cache_limit = 1M
query_cache_size = 16M
log_error = /var/log/mysql/error.log
expire_logs_days = 10
max_binlog_size = 100M
innodb_file_per_table = 1
mysql.cnf contains only
[mysql]
mysqld_safe_syslog.cnf contains only
[mysqld_safe]
syslog
I had a two and a half year old Virtual installation (already PHP7 and Mysql instead of MariaDb). Until now I ran a project with a rather small database on it and everything seemed to work. Now - when I tried to import this larger database it gave the same problem as mentioned in my previous posts.
In this case I decided to see what happened when I applied double the quotes trick to the entries that gave problems. After the first few escapes I kept the same problems. But then I got a general error. And then - after even more double quotes - I got a 500 error. So I looked into the mysql error log and I found hundreds of entries like this:
[Sun Oct 07 18:40:46.234657 2018] [core:error] [pid 16752:tid 2856221504] [client 222.209.12.214:52567] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace.
At the end I got the following three messages:
[Sun Oct 07 18:45:01.122183 2018] [fcgid:warn] [pid 16752:tid 2982112064] [client 222.209.12.214:56654] mod_fcgid: read data timeout in 40 seconds, referer:
http://www.mysite.com/phpmyadmin/db_import.php?db=babil&token=7d006c0845ff766babde1753b77ec170
[Sun Oct 07 18:45:01.122743 2018] [core:error] [pid 16752:tid 2982112064] [client 222.209.12.214:56654] End of script output before headers: import.php, referer:
http://www.mysite.com/phpmyadmin/db_import.php?db=babil&token=7d006c0845ff766babde1753b77ec170
[Sun Oct 07 18:45:01.356852 2018] [core:error] [pid 16752:tid 3024075584] [client 222.209.12.214:56880] AH00124: Request exceeded the limit of 10 internal redirects due to probable configuration error. Use 'LimitInternalRecursion' to increase the limit if necessary. Use 'LogLevel debug' to get a backtrace., referer:
http://www.mysite.com/phpmyadmin/import.php