Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Lost Database

chrissword30's profile image chrissword30 posted 2 weeks ago in General Permalink

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

chrissword30's profile image chrissword30 posted 2 weeks ago Permalink

here is a screenshot of what I get now when I trying accessing our database

1 attachment(s):
  • Untitled
ansgar's profile image ansgar posted 2 weeks ago Permalink

Besides the 3 system databases information_schema, mysql and performance_schema, I see a database named "z_readme_to_recover". That is not the database you expect to see there?

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.