import with mysql.exe aborts with maximum time execution exceeded-CodePudding

Using from XAMPP on Win10

Server version: 10.4.24-MariaDB mariadb.org binary distribution

mysql -u user -p db

source db.sql

I end up with the error below after way more then 300 seconds.

Fatal error: Maximum execution time of 300 seconds exceeded in D:\xampp-2022-06-09*

I know this error from using phpmyadmin, but here I use mysql.exe. Apache is not running. The directory mentioned in the error text is an old XAMPP installation not used here.

What am i missing ? I have scanned all ini files for mysql and php but have not found any entry specifiymg 300 seconds. I have loaded this huge db in the past but never seen this before.

What am I doing wrong ?

CodePudding user response：

Error 1064 as reported by the command line client is a syntax/parser error. You don't have any error related to maximum execution time.

If you open db.sql in an editor and search for "Maximum execution time" you will notice, that this message is in your data which you tried to import. Likely PHP stopped after 300 seconds and the error message was stored in this file.