distal-attribute
distal-attribute
distal-attribute
distal-attribute

Can HeidiSQL open a local "Mysql" database file (not server)

User, date Message
Written by BigMat
9 months ago
Category: General
3 posts since Mon, 28 Oct 13
Hi,

I have a local mysql DB file that I want to open. I don't have any mysql server running, just a DB file.
When I open HeidiSQL, I seem to only be able to connect to a DB server.

Thanks,

BM
Written by ansgar
9 months ago
4936 posts since Fri, 07 Apr 06
No, HeidiSQL can connect to servers only. I never came across a tool which reads out .myd files, apart from the mysql server itself.
Written by BigMat
9 months ago
3 posts since Mon, 28 Oct 13
these software exist, I found a few quite easily, for instance "SQL Maestro".
But since I only need to run a few queries and then extract the result in CSV, it didn't justify the cost of a licence. So I'm looking for a freeware.

Thanks for your prompt reply.

Thanks,

BM
Written by ansgar
9 months ago
4936 posts since Fri, 07 Apr 06
You could install a mysql server and place your files in some test database directory, and then connect via HeidiSQL.
Written by BigMat
9 months ago
3 posts since Mon, 28 Oct 13
Thanks for the suggestion, I think this is overkill for what I need to do, I'll try to find another solution.
 

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