hey guys, never got into database handling or using apache, however i've dabbled a bit with html coding and css. now the thing is, i have a .mysql file which is a database (i assume) and i would like to view the contents. i've installed mysql on my machine, tried running the server to open up the file, but it didn't work. i've also tried following instructions on the interweb where you set up ms access to run a server and open the .mysql, but it didn't work as i couldn't configure it properly (since some of the settings they wanted me to change were nonexistent on my computer). i've not tried putting together a site and implementing it, simply cause i find that to be quite a hassle and a big workaround. now, i turn to my fellow bit-techers knowing that many of you possess the secrets of opening .mysql files. how can i crack this case up? in the future i might want to implement it in a website, but that's i a distant future. right now i just want to access the data.
I dunno how to do this exactly, but what you're doing is a flat file backup/restore. Generally you'd create a new database with the same name/type, then overwrite the data file with your backed up file.
If you have phpmyadmin it's easy. Login, then along the top bar chose import and select your file. If not you will need access to mysql via the command line. Pick a walkthrough.
