path to the database

[expired user #1386]'s profile image [expired user #1386] posted 8 years ago in General Permalink

Hi! HeidiSQL operates on the MySQL database (right?). I cannot find where it reads its path. I explored the windows register (nothing) and My.ini. The latter says: datadir="C:/ProgramData/MySQL/MySDL Server 5.6/data\" But when I connect to MySQL the request "show tables;" says "tables in classique" -> lists albums and "select * from albums" -> "Empty set" ! albums.MYD is not empty (236 Ko). HeidiSQL shows nothing in the data tab. What's wrong?

ansgar's profile image ansgar posted 8 years ago Permalink

Do not expect rows only because the size of the .myd file is more than 0 bytes. If you don't believe HeidiSQL, you should check with a SELECT * FROM yourtable in some other MySQL client.

Please login to leave a reply, or register at first.