MySQL File Viewer

What is the easiest process to open and view a MySQL database file?  I have a DB file with the extension .sql.  I know this is a MySQL file, but I don't know what version of the database engine was used to create the file.  I have no MySQL tools installed and just looking for the fastest way to view the data.
dev775Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin MillerCTOCommented:
You can describe a DB with the command line, and get the version from the command line. Check this link for more info:

https://dev.mysql.com/doc/refman/5.7/en/mysql.html



 Also if you have access to installing phpMyAdmin you can get this in a visual GUI.
Dave BaldwinFixer of ProblemsCommented:
Almost all MySQL files in 'sql' format are text files so you can use a text/code editor like Notepad++ to view the contents.  http://notepad-plus-plus.org/
dev775Author Commented:
Yes, I can easily look at the data inside the MySQL database file using a text editor (I use UltraEdit), but what I am looking for is a tool with a user interface that will display the data in a structured tree, much like SQL Server Studio does for a MS database.  If phpMyAdmin is a good solution for this how does one go about installing the app?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Martin MillerCTOCommented:
phpMyAdmin is a server install, like a web application.  It does present a security risk if you leave exposed.
arnoldCommented:
Not quite sure I understand what you are after.
You have to load the file into a functional server to enable you to query.

There are MySQL online where you can load the data....
Dave BaldwinFixer of ProblemsCommented:
All the 'viewers' that I know of look at the data on a server, not a separate 'sql' file.
NerdsOfTechTechnology ScientistCommented:
You could run a temp local WAMP setup, like easyPHP, on a local computer and view it via phpMyAdmin; then shut down the temp server.

http://www.easyphp.org/
Tomas Helgi JohannssonCommented:
Hi!

You could use MySQL Workbench or DBeaver both free and easy to use.
If this is a backup file with DDL as well as the data you could set up newest MySQL DBMS on your computer and import the file then use the above tools to browse the data and do any alterations you need to do. :)

Regards,
     Tomas Helgi

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dev775Author Commented:
Thanks for all the helpful feedback!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.