mysql data missing

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • alondraatkins
    New Member
    • Jul 2017
    • 1

    mysql data missing

    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
  • MariahSalazar
    New Member
    • Jul 2017
    • 1

    #2
    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

    Working...