Solved

where does mysql store its data files in windows 8

Posted on 2014-01-16
3
498 Views
Last Modified: 2014-01-22
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
0
Comment
Question by:andieje
  • 2
3 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 39785678
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
 

Author Comment

by:andieje
ID: 39786088
Thanks Kevin, but why is my indata1 file only 1 gig when my combined database total in 8 gig?
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39786144
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Creating and Managing Databases with phpMyAdmin in cPanel.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question