Need to restore data from dump on diff machine without access to original

[Oleg Gabrielov]

Hello everyone,

I am completely new to MySQL, so all your help is really appreciated.

We have our Internet service provider host our app which uses MySQL for data. We have a situation where we need to take our data in-house to evaluate a new version of our app.

Our ISP used mysqldump to dump our database into a .sql file and sent it to us. They refused to give us anything more, like the actual data files, etc.

I tried using mysqlimport to restore all that data to our in-house MySQL, but get nothing but errors.

Please note, our local MySQL instance doesn't have the database our ISP has or any tables associated with it. My assumption was that mysqlimport will be able to recreate the database itself and all the tables associated with it. However, it seems to be complaining that neither the database nor the tables currently exist and refuses to do anything.

Can someone please tell me what I need to do to restore mydata considering that I have no access to anything our ISP has besides this .sql dump file.

Thank you so very much in advance.

Oleg.