I am still new with HeidiSQL so in depth things I do not know, I just know the basics of doing queries. However my problem is, that me and some friends are running a gameserver, and we needed to create a password through xaamp. I had trouble getting password created so I had to go and place a command in the my.ini under msqld skip-grant-tables. It appeared to work, but this morning I went to restart our game server and i recieved mysql errors. I logged in to our VPS and saw that mysl encountered a problem and stopped. I restarted it and restarted our server and recieved same errors in the server. I then tried to log into our database through xaamp which defaults to phpMyadmin, and there was no database there, I then tried to go through HeidiSQL and it also shows that there is no database. I am not quite sure how our database disappeared just by attempting to change a password, when I tried to look for information on line, all i have been seeing in regards to possibilities is if we upgraded to a newer version in which we did not. Any help retrieving our database will be greatly appreciated. Thank you
Please login to leave a reply, or register at first.