I work for a doctor's office, and we are in the process of switching EMR systems. The previous system has provided a physical 'dump' of the database. I however, don't know how to open this database and view the contents therein. The file is 1.2 gb with less then 1000 lines of SQL commands so I assume that all of the data is there. Here's what I've tried thus far:
- Opened in a text reader: All it shows is a bunch of SQL commands to create the database tables
- Installed MySQL Workbench and tried to create a "EER Model From SQL Script": This just creates the database structure.
- Using MySQL Workbench/Setup a 'localhost' server: Tried a 'import' of the .sql file onto the newly created 'server' but it doesn't work and spits out an error
What are some steps to properly opening and obtaining the data found within a MySQL data dump?
I'm VERY new to the whole database management so if I've missed any details feel free to prompt.