Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm a linux user, however, I'm provided with a Windows laptop in the office. I could fire up a small web server with PHPmyadmin or even upload to a remote system and import into a database, however, for what I'm doing, I'd like to know if there is anything easier?

What I have is a MySQL Dump file of a database. I need to know if there is anything out there that can read in a MySQL dump file and then allow me to perform selects (to lookup data), without my having to have an actual MySQL database. Almost like a virtual MySQL database as a file sort of thing. Basically, I'm trying to cross reference data, and I don't exactly want to create a new database, do the import, and then read the data like that. I will if I have to, but was just wondering if there was some sort of program that would read my dump file and let me just view it as if I was connected to the database.

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

There are a few tools out there for viewing the dump files out there. Keep in mind that it's just a huge text-file with sql commands. Any SQL Query Analizer tool out there can typically open and view the files. There is no tool (that I've seen) that will let you treat the txt file as an editable database. Even the MYSQL Workbench GUI has one built-in.

As a slightly-easier method of importing/modifying/etc the dump files, just use the mysql workbench to import the dump file into a locally running DB server... and export it back out when done. No need for the entire php framework with myPHPAdmin... and apache... and everything else.

share|improve this answer
    
Yea - that's what I thought. Thanks for the suggestion - this is where I was headed if there wasn't something out there. –  drewrockshard Nov 1 '12 at 15:42
add comment

If you don't want a full fledged local mysql installation you could also import your mysql-dump into a sqlite database and (temporarily) work with this. For converting the mysql-dump you could use this ...

share|improve this answer
add comment

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.