Solved

where does mysql store its data files in windows 8

Posted on 2014-01-16
3
492 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now