stand alone SQL tool?

[whackaxe]

over the past..... while? i have been using SQLyog 2.5.1 for my sql administration during development. i went back onto their site to see if there were any updates and realised that they were on 3.5 and you had to register the software! (2.5.1 was freeware).

does anyone know of any standalone sql managment software like sqlyog. i say standalone because i don't want people to link me to phpmyadmin :p

thats all :)

[raf]

MySQL front --> http://www.mysqlfront.de/

Gets my 10/10 (but then again, i'm a bit less critical this time of year).

[Jon T]

I would agree with Raf, however, I still for the life of me have not been able to find a way to import .sql files.

For Giggles I installed PHP Nuke, and could not get the phpnuke.sql file to import, but I could get it working with PHPMyAdmin.

Anyone know how to import .sql files in MySQL Front and not get an error? I'm using 2.5

[raf]

I don't have it on my machine here, but isn't there

1. a button on the toolbar of the mainpage, right next to the create dumpfile. Something like read from textfile ...
--> a dumpfile is just a textfile with the sql-statements to recreate the db/tables/records

2. Or open the sql-editor
http://www.mysqlfront.de/modules.php?name=Content&pa=showpage&pid=1&page=5
and then look for a button to open the textfile (probably the one on the left of the lowest toolbar (or just hoover over each button.)

3. <edit>or rightclick in the sql-editor and hit 'paste for file' -->just seen it on the screenshot</edit>

4. or just doubleclick on the file in explorer. There's a good chance that .sql files will be associated with mySQLFront so itwill open a new MySQLfront windw and display the file in the sql-editor.

I'm not sure about v2.5 but 1, 2 and 4 should also work on that older version (if i remeber correctly)

[Jon T]

Ya, I have done all of those, the first was import from the menu, the second was copy and paste sql code in editor and I still get an error saying. MySQL Error on Line G.
:confused:
I always get line number errors, what the hey is Line G?

I have in the past been able to import text files, etc, but for some reason, this one file is not wanting to do anything. So I downloaded and installed PHPMyAdmin, and it worked..

Humph... One day I will fiture it out! :thumbsup:

[raf]

Never had any problem with it and there certainly is not a general problem for executing dumpfiles, like i interpreted your previous post.

[Jon T]

Ok, have to find out why a group of 6 people can not figure this out. ;-) Maybe we were just drinking to much. ;-)