Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • Were all the tables using InnoDB ? Commented Jan 27, 2015 at 23:31
  • Please go to my post dba.stackexchange.com/questions/8661/…, look for the bold heading Total MySQL Data and Index Usage By Storage Engine and run that query please. Does it report any data ? Commented Jan 27, 2015 at 23:33
  • 1
    Please run this SELECT variable_name FROM information_schema.global_variables WHERE variable_name IN ('datadir','innodb_file_per_table','innodb_data_file_path','innodb_data_home_dir'); What are the values ? Commented Jan 27, 2015 at 23:35
  • I am sorry wrong query. Please run this: SELECT * FROM information_schema.global_variables WHERE variable_name IN ('datadir','innodb_file_per_table','innodb_data_file_path','innodb_data_home_dir‌​'); Commented Jan 28, 2015 at 16:04
  • As shown, you have 1.608 GB of MyISAM, 210MB of InnoDB. Therefore, your data is not missing. Commented Jan 28, 2015 at 16:16