Not every of mysql databases has such problems. Some days ago something happened, and my changes in database are disappeared. Now I don't know how to be. I am on MySQL 5.6
mysql data missing
Collapse
X
-
Tags: None
-
I know that your problem can be serious, but see guide below
In case it isn't be effective, then look at this thing mysql repair tool, that was found in Google couple days ago
Step 1. Log into mysql as administrator
mysql -uroot –p
Step 2. Select the database containing the corrupted table, i.e., ‘use {database name};’
mysql> use {database name};
Step 3. Show tables your corrupted table should be listed
mysql> show tables;
Step 4. Repair table
mysql> repair table {bad_table_name };
Comment