MySQL Forums
Forum List  »  MySQL Administrator

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

Written By
Importing phpMyAdmin sql file into MySQL Administrator
April 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.