PHP mySQLi:: MySQL server has gone away

Asked Feb 10 '15 at 18:14

Active Feb 10 '15 at 18:14

Viewed 990 times

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...

asked Feb 10 '15 at 18:14

davidmarko

1

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
@RiggsFolly Must run this thru php – davidmarko Feb 10 '15 at 18:24
Can you give us some idea of what is in the HUGH.sql file – RiggsFolly Feb 10 '15 at 18:25
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
Around 60,000 Lines of "INSERT INTO"... Pretty Big! – davidmarko Feb 10 '15 at 18:29

0 Answers0