CODEWITHSUNDEEP
mysql
TCM
TCM

Reputation: 16900

How did my mysql database get deleted automatically?

I am very sure that i didn't delete my database and noone else sits on my machine. Then how did i my database get deleted automatically? I had 10 tables in it :(. Infact 2 databases got deleted automatically. They are not being shown in mysql query browser. How can i recover my databases back? Is there any query which will help to show the logs to see if the delete schema command was actually fired in mysql? I am very much frustrated. Please help. The last time i saw these database alive was before 2 weeks and today they are no more.

Upvotes: 0

Views: 9514

Answers (3)

Deepak S Jois
Deepak S Jois

Reputation: 1

We had similar problem where we lost all the tables of the database but the database remains as it is in the mysql. The problem and the solution is as follows:

  1. Check where you have installed your MYSQL/XAMPP/WAMP
  2. Check whether you have all the permissions to install the MYSQL/XAMPP at the place where you have installed your XAMPP/MYSQL on your desktop/server.

The solutions is simple, just re-install your XAMPP/MYSQL on your desktop/any other location where you have permission to install. Your will not get this problem in future. Please do not forget to check your error logs and take necessary actions after checking logs daily.

Upvotes: -1

Abnish Pathak
Abnish Pathak

Reputation: 11

Your database is not deleted from MySQL. You would have set your own user and password in user table when you created these tables. However the when You open my SQL it takes root as the user by default and password as NULL. So to fix it and to see your database and tables you need to set your username and password in config file of MySql.

Example:- If your username and password is XYZ you need to set them as below in config file(config.inc). path for this file would be:-C:\wamp\apps\phpmyadmin4.1.14 (depending on the version you have installed)

$cfg['Servers'][$i]['user'] = 'XYZ';
$cfg['Servers'][$i]['password'] = 'XYZ';

Upvotes: 1

PurplePilot
PurplePilot

Reputation: 6612

could be you are looking at them with a different user credentials that does not have sufficient privileges to see them?

What tool are you using to view them? command line, phpmyadmin etc?

Yes there are logs you can go through see here

Upvotes: 1

Related Questions