Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to create a database in MySQL Server 5.5. The database is created, I know this as when I do

SHOW DATABASES; 

It shows me my database in the list of all databases from the commandline.

But when i go inside

C:\Program Files\MySQL\MySQL Server 5.5\data\

my database is not visible there. In fact with

SHOW DATABASES; 

it shows me 6 databases in the list but inside

C:\Program Files\MySQL\MySQL Server 5.5\data\

shows only two databases.

Its really strange error I m experiencing, the database is created but not actually created feels like the commandline is cheating with me!

thanks for the help in advance!

share|improve this question
    
Are you running 32-bit MySQL on 64-bit Windows? Check "Program Files (x86)". –  db2 May 28 '13 at 23:00
add comment

migrated from stackoverflow.com Feb 5 '12 at 4:02

This question came from our site for professional and enthusiast programmers.

1 Answer

Please check the my.cnf in the mysql installment folder.

like this:

datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

it will show you the right folder.

share|improve this answer
    
Thanks Eric Already checked it, it shows the same path datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/" I noticed I have 3 different installations: Microsoft SQL Server; Xampp; MySQL Server 5.5; may be this has to do something with my bug, not sure –  vats Feb 4 '12 at 11:40
    
ugh, I want to make this a comment >.< –  jcolebrand May 28 '13 at 19:55
    
@jcolebrand Why can't you make it a comment (is it because it has an upvote) ??? –  RolandoMySQLDBA May 28 '13 at 22:18
    
Because it doesn't have an associated user on our site. Gray ghost name. –  jcolebrand May 28 '13 at 22:26
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.