Default Databases

1 posts
nonsatisfaction's profile image nonsatisfaction posted 2 years ago in General Permalink

Hello I just downloaded HeidiSQL and accidently deleted some of the databases, I only have information_schema, and mysql. There were a few others but I accidently deleted them. How can i get them back??

1 attachment(s):
  • image_2023-06-11_235743429
10429 posts
ansgar's profile image ansgar posted 2 years ago Permalink

Well, there is no recycle bin I'm afraid. If you delete a database - by accident or intentionally - you actually send a DROP DATABASE xyz; command to the server. If you don't have a backup then these are gone. Probably the server has some automatic backup system, however.

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