so there i was, i was loading some heavy data into mysql database, it was running for a while now. and at the same time, i had started a ssh session on my server. then i accidentally restarted mysql server. as soon as the mysql server was restarted, i saw this error:
Warning: mysql_query() [function.mysql-query]: Unable to save result set in /var/www/counts.php on line 29
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/counts.php on line 30
SQL ERROR LINE: 39
Lost connection to MySQL server during query
so basically, you are probably getting this error message also because the connection to your mysql was lost. did you powered off your server? did you lose power? did it crashed?
you might want to ping your server to see if its running, if it is, try restarting your server, this is the command i used to restart my database server:
hope that helps