simple question on mysql

[NeoGen]

Just got my hands on a mysql database that I would very much like to poke inside, but I'm lacking software for it...

I've already downloaded and installed the mysql binaries (v5.0).
Can anyone point me to a program that I can get to open the database and poke around inside it? And that runs on Windows... :roll:

[Evil-Dragon]

If you have apache with php you could try phpmyadmin. I've used it briefly, mainly to test setting up Wiki's/PHP Powered sites.

[vaughan]

NeoGen, when Doomeva is back on Friday night I'll ask him about this. He has all sorts of mysql and Apache stuff on his PC.

[NeoGen]

Never tried apache, don't even know what it does actually. But I'll download and explore it a bit.

And I assume that it's the "Apache HTTP Server Project" that you're talking about, right? On the apache foundation site there's a bundle of projects being developed, but if on an alphabetically sorted list that one comes up first (out of place) it must be for a reason.

Where is a simple application when we need one? :roll:

[cicide]

http://www.mysqlfront.de/

This is what I use, runs on windows.

[Anonymous]

That's a darn good app. Not seen that one yet. Thx.

Another you can use for a quick (30 day) "poke around" is navicat
http://www.navicat.com/download.html

[AMDave]

looky thar! I forgot to log in again.

If you really get the "bug" you can get the entire kit-n-kaboodle here
http://www.apache-mysql-php.com/?artclno=77

[NeoGen]

This is getting annoying... :? I've come to the conclusion that the database file in itself has something wrong because none of the above programs "sees" it.

I assume it is a mysql database because the extension of the file is .mysql (and it's one single massive file), but then I looked on the mysql folder for the already existing databases and tables and stuff and there is nothing with that extension. All I see is .MYI, .MYD, and .FRM. (And they always appear in triplets)

Could it be that older mysql versions used that extension but nowadays it was dropped?

[Strongbow]

.MYI = index file
.MYD = data file
.FRM = format file

So you do need them, but further than that my knowledge on mySQL gets weak as I haven't used it in years!


EDIT:
This site & link might get you moving again http://dev.mysql.com/doc/refman/5.0/...lic-links.html

[vaughan]

Doomeva says he uses phpmyadmin.