phpMyAdmin locks up when trying to run a query, or import .sql file

Section with additional software for Vesta
youradds
Posts: 65
Joined: Tue Sep 01, 2015 10:16 am

phpMyAdmin locks up when trying to run a query, or import .sql file

Postby youradds » 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

Return to “3rd Party Software”



Who is online

Users browsing this forum: No registered users and 3 guests