where does mysql store its data files in windows 8
Posted on 2014-01-16
I am looking at a mysql server 5,6 running innodb on windows 8 and my database appears to be 5 gig in size based on this query
SELECT table_schema "databasename", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;
There are a few other databases on the server making the whole lot about 8 gig. However when I look at the C:\ProgramData\MySQL\MySQL Server 5.6\data\ibdata1 file it is only 1 gig in size. Please could you advise where the other data is? How do I find out the entire size requirements of a mysql installation including all of its databases?