Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

restoring or browsing mysql sql file

I have received a copy of what should be a mysql database in the format *.sql. I need to try and restore it to see if it contains some data we need to move into an archvie access database. Are there any free tools that can be used to browse the mysql data that run on windows? I am not sure if the sql format is what mysql uses as an extention for its data, e.g. similar to mdf for MSSQL
Avatar of Deepak Chauhan
Deepak Chauhan
Flag of India image

You can download Workbench for Windows provided by MySQL at link given below.

ASKER CERTIFIED SOLUTION
Avatar of Jim Riddles
Jim Riddles
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
install MySQL server community edition and create a dummy database. Import the backup to the database.
View the data using mysql quyries or using SQLYOG/workbench