Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm using HeidiSQL to access my remote MySQL db.

Recently I was sent an .sql file.

Is there a way to open this file using HeidiSQL? Does anyone know of a better way to graphically view and manipulate a local sql file?

I know that in windows Heidi associates with sql files but when double clicked nothing happens.

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

(This part lifted from my answer here...)

The first thing to note is that an .sql file is not a MySQL database. It is a script file containing SQL statements. You would run such a script against the database platform for which it was written (using the SQL dialect for a specific SQL database engine) to create the actual database.


From comments to other answer:

I was wondering if there is a way on Heidi or another program to do this without setting up a server.

No, you need a server somewhere. If there was any stand-alone tool that could "graphically manipulate" an .sql file (containing DDL, I presume) then it would have to have its own MySQL server embedded in it.

share|improve this answer
add comment

You could of course just use any text editor such as Notepad to edit the SQL file and then paste the result in the Query screen indicated here: http://www.heidisql.com/screenshots.php?which=query

Make sure though that you use an ANSI text editor and that if you have any non standard characters, that they are pasted correctly.

share|improve this answer
    
Nice idea, but this is a pretty big file ~10Mb –  hitautodestruct Apr 10 '13 at 12:31
    
I would assume that the file does a lot more than just one or two queries. Is there any reason you cannot use the normal mySQL tools? –  RoKa Apr 10 '13 at 12:33
    
I could and probably will use phpMyAdmin but I was wondering if there is a way on Heidi or another program to do this without setting up a server. –  hitautodestruct Apr 10 '13 at 12:35
    
Well, you would certainly not have to set up a server just to install the mySQL Workbench (would you?) --> dev.mysql.com/downloads/tools/workbench –  RoKa Apr 10 '13 at 12:38
    
@hitautodestruct : I just downloaded this tool, and it looks like from the Tools menu, you can select Load SQL File. Have you tried that option yet? –  RoKa Apr 10 '13 at 12:48
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.