Importing phpMyAdmin sql file into MySQL Administrator

[Mark Lett]

Is there an easy way to import a database from phpMyAdmin sql file dump into MySQL Administrator? I have tried copying and pasting the sql statements into the MySQL Query Browser but there seems to be a problem with using SQL with comment blocks in it and not being able to set a database name for the whole file. At present it seems very manual and takes a lot of time to clear all the comments and add the 'tablename'. syntax to every sql query. There must be an easier way to do this.

Many thanks