distal-attribute
distal-attribute
distal-attribute
distal-attribute

Converting SQL file?

User, date Message
Written by NoWayln
6 years ago
Category: General
7 posts since Tue, 29 Jul 08
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
Written by ansgar
6 years ago
4785 posts since Fri, 07 Apr 06
Are you double clicking a .sql file or what?

Any chance you tell us the exact error message so we can probably help you?
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
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.
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
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
Written by Dr. DaveMoney, Euro
6 years ago
100 posts since Sun, 27 Jan 08
So many questions... I don't know where to begin...

NoWayln wrote: 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:

NoWayln wrote: i Export my database from Heidi SQl


NoWayln wrote: 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.
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
Oh, i export it before it stop working.
Written by Dr. DaveMoney, Euro
6 years ago
100 posts since Sun, 27 Jan 08
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.
Written by ansgar
6 years ago
4785 posts since Fri, 07 Apr 06
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.
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
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
Written by ansgar
6 years ago
4785 posts since Fri, 07 Apr 06
Just be patient. It freezes because it's busy executing the contained SQL.
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
Well it was about 70% of the way and there was an error.

i'll post what that error is back later
Written by NoWayln
6 years ago
7 posts since Tue, 29 Jul 08
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
 

Please login to leave a reply, or register at first.