phpMyAdmin locks up when trying to run a query, or import .sql file
Posted: Thu Apr 06, 2017 1:18 pm
Hi,
For some reason mySQL goes into melt down when I try and upload a 500kb .sql file. I eventually get a 500 IS error, but no error message.
I've got it setup to allow 20mb POST max, 20mb file uploads, etc... so I'm not sure what else would cause it. If I run the query from the .sql file via "SQL", it looks like its about to work, but just hangs (eventually timing out). After that, I can't even access phpmyAdmin. The only way around it is to reboot mysql (it goes to over 100% CPU consumption)
Has anyone else seen behavior like this? I'd prefer to fix it before I put any of my sites on it, otherwise it'll cause me headaches later on :/
Cheers
Andy
For some reason mySQL goes into melt down when I try and upload a 500kb .sql file. I eventually get a 500 IS error, but no error message.
I've got it setup to allow 20mb POST max, 20mb file uploads, etc... so I'm not sure what else would cause it. If I run the query from the .sql file via "SQL", it looks like its about to work, but just hangs (eventually timing out). After that, I can't even access phpmyAdmin. The only way around it is to reboot mysql (it goes to over 100% CPU consumption)
Has anyone else seen behavior like this? I'd prefer to fix it before I put any of my sites on it, otherwise it'll cause me headaches later on :/
Cheers
Andy