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
You can download Workbench for Windows provided by MySQL at link given below.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
View the data using mysql quyries or using SQLYOG/workbench