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.

hitautodestruct
  • 113
  • 1
  • 4

2 Answers2

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.

Community
  • 1
Gord Thompson
  • 1,277
  • 9
  • 13
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.

RoKa
  • 1,614
  • 11
  • 16