where does mysql store its data files in windows 8

Hello

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?

thanks
andiejeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Are all your tables INNODB?
In other words, if C:\ProgramData\MySQL is indeed your data directory, the ibdata1 usually is the data file; however, you can have individual files (file-per-table configuration).  Therefore, check under other folders in the data directory for .ibd files.  In addition, if you see any .my* files, you have some MyISAM tables also.
0
 
Kevin CrossChief Technology OfficerCommented:
The system tables go to C:\ProgramData\MySQL if you do not specify a different path, but I for example have mine under C:\RDMS\MySQL.  If you open the INSTANCE > Options File from the MySQL Workbench, you should see option datadir that you can set to the path your desire (e.g., mine looks like "C:/RDMS/MySQL/data\").
0
 
andiejeAuthor Commented:
Thanks Kevin, but why is my indata1 file only 1 gig when my combined database total in 8 gig?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.