Getting MySQL Database Error: Unable To Save Result Set In ...

Forums » MySQL » Getting MySQL Database Error: Unable To Save Result Set In ...
are you getting this error on you php pages with mysql that says Warning: mysql_query() [function.mysql-query]: Unable to save result set in line xx - well if you want to know what this error means i will try to explain what i was doing when i got this er
are you getting this error on you php pages with mysql that says Warning: mysql_query() [function.mysql-query]: Unable to save result set in line xx - well if you want to know what this error means i will try to explain what i was doing when i got this error myself.

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:

/etc/init.d/mysqld restart


hope that helps
Title: Getting MySQL Database Error: Unable To Save Result Set In ... [923]
Tags: mysql error unable to save result set in
By
Comments 0
Visits 1185