Windows 7 Forums


Reply
Thread Tools

[SOLVED] MySQL on Windows 7

 
 
cearlp cearlp is offline
New Member
Join Date: Dec 2009
Location: Utah
Posts: 3
Thanked: 0
 
      12-28-2009
I installed MySQL 5.1.41 on Windows 7 using an MSI file downloaded from mysql.com. The installation seemed to go okay but I can't find the 'data' directory that should contain the mysql test database and where I could copy my previously created mysql database.
Does anybody have an insight as to where the database files go?
 
Reply With Quote
 
 
 
 
Thrax Thrax is offline
Super Moderator
Thrax's Avatar
Join Date: Apr 2009
Location: Detroit Metro
Posts: 926
Thanked: 262
Send a message via ICQ to Thrax Send a message via AIM to Thrax Thrax's Twitter Pag
 
      12-30-2009
Do you know where the MySQL directory you are looking for is usually stored?
 
Reply With Quote
 
cearlp cearlp is offline
New Member
Join Date: Dec 2009
Location: Utah
Posts: 3
Thanked: 0
 
      12-31-2009
The data directory should be under the MySQL install directory. i.e., C:\Program Files\MySQL\MySQL Server 5.1

The bin, Docs, lib and share directories are there as well as multiple configuration files, but no data directory.
However, the show databases command lists information_schema, mysql and test but I don't know where they are physically located.
 
Reply With Quote
 
Ian Ian is online now
Administrator
Ian's Avatar
Join Date: Oct 2008
Location: England
Posts: 3,090
Thanked: 450
Ian's Twitter Pag
 
      01-03-2010
Can you try opening the my.ini file to see if it shows where the data directory is? It should look like this:

Code:
 
datadir="C:/MySQL/Data/"
I've got the latest MySQL installed ok on my Windows 7 machine.
 
Reply With Quote
 
cearlp cearlp is offline
New Member
Join Date: Dec 2009
Location: Utah
Posts: 3
Thanked: 0
 
      01-06-2010
Thanks for all the help everybody.
I found that the data directory is located just where the my.ini file specifies it to be.
It is under the mysql\mysql server 5.1 directory, but it is set up as a hidden file.
 
Reply With Quote
 
Ian Ian is online now
Administrator
Ian's Avatar
Join Date: Oct 2008
Location: England
Posts: 3,090
Thanked: 450
Ian's Twitter Pag
 
      01-06-2010
Excellent, I'm glad it's fixed! I've marked this thread as solved.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Install Windows 7 davehc Software 0 08-16-2010 03:50 PM
Windows 7 Annoyances Nibiru2012 General Discussion 6 03-17-2010 07:17 PM
Clean Install Windows 7 with Upgrade Media Nibiru2012 Installation, Setup and Updates 0 12-22-2009 08:03 PM
Clean Install Windows 7 with Upgrade Media Nibiru2012 Installation, Setup and Updates 2 12-04-2009 07:30 PM
Important Issues in This Release Candidate of Windows 7 Ian News 0 05-05-2009 04:25 PM


All times are GMT +1. The time now is 12:40 PM.
W7Forums is an independent website and is not affiliated with Microsoft Corporation.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33