1

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.

Improve this question

2 Answers 2

Reset to default
1

(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.

Improve this answer
0

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.

Improve this answer
8
  • Nice idea, but this is a pretty big file ~10Mb
    – hitautodestruct
    Commented Apr 10, 2013 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
    Commented Apr 10, 2013 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
    Commented Apr 10, 2013 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
    Commented Apr 10, 2013 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
    Commented Apr 10, 2013 at 12:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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