Converting SQL file?

Is there a way for me to convert Heidi SQL to MySQL?

when ever i open Heidi SQl i gets an error, i press OK and it goes into Heidi, but another error pops out

i ept on clicking ok and it keeps on poping back, it wont go away

Are you double clicking a .sql file or what?

Any chance you tell us the exact error message so we can probably help you?

i Export my database from Heidi SQl
Now i want to convert that file to MySQl
( MySQl Query Browser)

Let me edit my post and post the error i get.

Ok this is what the error is right when i try to logo into Heidi SQL

Access Violation at address 0064EA33 in module "heidisql.exe" read of address 000000000

Once i click ok Heidi comes up and the same message shows up, it wont go away

So many questions... I don't know where to begin...

Is there a way for me to convert Heidi SQL to MySQL?

Apples and Oranges. MySQL is a relational database management system that runs as a server providing multi-user access to a number of databases. HeidiSQL is the client (application) that allows you to connect to, and manage the MySQL data and basic infrastructure. So, you're question, "Is there a way to convert HeidiSQL to MySQL", the answer would technically be "No". They are two entirely different entities.

There is something else I don't understand about the information you've provided. These two statements contradict each other:

i Export my database from Heidi SQl

Ok this is what the error is right when i try to logo into Heidi SQL

Access Violation at address 0064EA33 in module "heidisql.exe" read of address 000000000

Once i click ok Heidi comes up and the same message shows up, it wont go away

If you can't get HeidiSQL to even run, how did you export your database from HeidiSQL?

I have many more questions but I'll wait for your response.

Oh, i export it before it stop working.

So, ... and correct me if I'm wrong..., what you're wanting to know is if there is a way to convert your .sql file that you exported and turn it into .MYD, .MYI, and .FRM files for MySQL to read?

If so, no. There is no possible way to do that without parsing your .sql file queries thru a MySQL interpreter. Now, if you want, you can run MySQL queries thru the MySQL's command line interface, so long as you selected the command interface operability during MySQL installation and setup.


Now, in regards to your HeidiSQL "Access Violation" error, I don't know what to tell you other than try uninstalling and re-installing Heidi.

There's too few details here about the reported error so I'm reading between the lines. Very likely your access violation goes away if you upgrade your heidisql.exe with a newer build. You can download such a build here and replace your c:\Program files\HeidiSQL\heidisql.exe with the new file.

Thanks anse, my HeidiSQl is working once again

now can you guys help me with importing the .SQL file i export from heidi?

do i click import>import SQL file

then either press yes to run it without loading into the script thing, or no for loading it then run it

it freezed on me last time

Just be patient. It freezes because it's busy executing the contained SQL.

Well it was about 70% of the way and there was an error.

i'll post what that error is back later

ok heres what happen while it went through the script

SQL Error: You have an error in your SQL syntax ; check the manual that corresponds to your MySQL server version for the right syntax to use near '2008-06-20 20:54:00');
REplACE INTO "gmlog"("id","c