PHP mySQLi:: MySQL server has gone away

Question

I'm trying to append a hush database directly from php.

$mysqli->query(file_get_contents('huge.sql'));

but I'm getting :

Warning: mysqli::query(): MySQL server has gone away in

I was add those 2 line at the beginning of my php code :

ini_set('mysql.connect_timeout',3000);
ini_set('default_socket_timeout',3000);

Not very helpful...

just how big is "huge"? don't forget that your query strings are limited by the `max_allowed_packet` setting, and anything past the max setting will be silently truncated. — Marc B, Feb 10 '15 at 18:17
better read the file line by line and do a query for each, assuming 1 line = 1 query. — Andrei Nikolaenko, Feb 10 '15 at 18:21
Do you have to run this through PHP or could you just use the MySQL command prompt? — RiggsFolly, Feb 10 '15 at 18:22
Not how big it is! What is IN the file? P.S. Edit your question dont paste something in a comment!!! — RiggsFolly, Feb 10 '15 at 18:28

score 0 · Answer 1 · answered Jun 16 '22 at 12:20

Unless you're getting an actual error and not a Warning, this doesn't necessarily mean you're doing something wrong.

With PDO for example, this warning can be issued when pooled connections are in use, such as when PHP is running as an Apache Module. There is a similar post here: How to fix the "server has gone away" warning when mysqli reconnects a persistent connection?

If what you're getting is simply a warning, and the query runs fine anyway, then you can either choose to request a persistent mysql connection, or ignore and suppress the warning.

If you're getting an error and your connection is getting terminated, then you should see https://dev.mysql.com/doc/refman/8.0/en/gone-away.html for most common causes of this issue.

It's not a warning anymore. It might have been a warning in the older PHP versions, but not anymore. — Dharman, Jun 17 '22 at 08:21

PHP mySQLi:: MySQL server has gone away

1 Answers1

Linked