How do I batch "restore"/import all tables from an external sqldump file?

[joemcl]

I have a MySQL sqldump file that is a backup of our data from an external service that we use. I'm loading up the data to whittle down our records in the external service by IDing bouncing e-mail addresses, etc. Unfortunately I can't connect to the service's backend MySQL database - it's design etc is proprietary. I simply asked for and received the sqldump of our data.

I've figured out how to "restore"/import one of the tables into dbForge, and then export that table to use in MS Access to more quickly create the queries I want.

Now, I want to restore all the tables as a batch from my sqldump file into dbForge, then export all/many to import into Access. Can I do that? I want to avoid the tedium of importing/restoring and then exporting each individual table, there are dozens.

Thanks for any help.

[alexa]

This could be achieved with the 'Restore Database' feature as follows:

1. Create a new database by right-clicking a connection in Database Explorer and selecting 'New Database...' from the popup menu.
2. Right-click the newly created database and select 'Backup and Restore -> Restore Database...' from the popup menu.
3. Complete the wizard.

Please also see the 'Database Backup and Restore' topic in the product's Help documentation.