Skip navigation links

MySQL Forums :: MySQL Administrator :: Importing phpMyAdmin sql file into MySQL Administrator


Advanced Search

Importing phpMyAdmin sql file into MySQL Administrator
Posted by: Mark Lett ()
Date: April 27, 2010 08:57AM

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

Options: ReplyQuote


Subject Written By Posted
Importing phpMyAdmin sql file into MySQL Administrator Mark Lett 04/27/2010 08:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.