Text only | Text with Images

ElkArte Community

General => Chit Chat => Topic started by: Jorin on April 24, 2017, 01:43:38 am

Title: SQL tool?
Post by: Jorin on April 24, 2017, 01:43:38 am
At work I am using Toad (https://www.quest.com/toad/) to work with the database. Yep, I need to in the future, as I am changing from technical illustrator to an administrator for our graphic information system (I am working at an energy supply company - sorry if the words are a bit unusual, I must use Google translator a few times  :D  ) in the next years.

Is there any tool to work with the databases of my ElkArte installations? A standalone tool with a local installation? Not MySQL?
Title: Re: SQL tool?
Post by: badmonkey on April 24, 2017, 07:14:24 am
Have you looked at mysqldumper?  I used it once on another server.  Been thinking of installing it again.  Not sure what you want the tool to do.  It does pretty much anything phpmyadmin does.  Plus it will backup and restore large databases.  
Title: Re: SQL tool?
Post by: Jorin on April 24, 2017, 07:22:12 am
I use MySQLDumper as backup tool. Didn't know it has a good SQL Editor too? I use Notepad++ too.

Well, I think I want to use a programm on my computer which connects to a set of databases, shows their tables, let me edit fields and edit the entries with SQL commands too. I know PHPMyAdmin can do this, but it's not really comfortable. There's no UNDO for example.
Title: Re: SQL tool?
Post by: Spuds on April 24, 2017, 07:49:37 am
I use Adminer (https://www.adminer.org) its a single file PHP based database manager.
Title: Re: SQL tool?
Post by: live627 on April 24, 2017, 12:51:21 pm
How did I miss that? :o
Title: Re: SQL tool?
Post by: Frenzie on April 24, 2017, 01:43:57 pm
Huh, that's awesome. I'd never even heard of it.
Title: Re: SQL tool?
Post by: emanuele on April 24, 2017, 03:32:19 pm
https://www.quest.com/products/toad-for-mysql/ ?

Found at https://www.quora.com/What-is-the-best-MySQL-client-for-Mac-OS-X-or-Windows
Title: Re: SQL tool?
Post by: Jorin on April 25, 2017, 12:57:42 am
Toad costs more than 1.000 Euro as basis installation. Too much for a hobby.  ;)
Title: Re: SQL tool?
Post by: Jorin on April 25, 2017, 01:28:04 am
Quote from: Spuds – I use Adminer (https://www.adminer.org) its a single file PHP based database manager.

Looks perfect! Thanks!  :)
Title: Re: SQL tool?
Post by: inter on April 25, 2017, 03:12:50 am
try MySQL Workbench Community
Title: Re: SQL tool?
Post by: emanuele on April 25, 2017, 05:02:18 am
Quote from: Jorin – Toad costs more than 1.000 Euro as basis installation. Too much for a hobby.  ;)
Ooops I didn't notice it required payment.... :-[

The other link, though, may have something interesting:
Quote from: emanuele – Found at https://www.quora.com/What-is-the-best-MySQL-client-for-Mac-OS-X-or-Windows

And what inter mentioned as well. :)
Title: Re: SQL tool?
Post by: ahrasis on April 25, 2017, 10:22:21 pm
Quote from: Spuds – I use Adminer (https://www.adminer.org) its a single file PHP based database manager.
Great. This adminer however did not work in php7.1. It works fine in php7.0 though.
Title: Re: SQL tool?
Post by: Jorin on June 08, 2017, 03:00:59 am
Thanks for the information, @ahrasis. No problem for me though...
Title: Re: SQL tool?
Post by: ahrasis on June 08, 2017, 07:09:02 am
I have reported it but they also said it is working with theirs too. So it may just be my setup then.
Title: Re: SQL tool?
Post by: Jorin on June 08, 2017, 07:15:22 am
I gave a "like", but then I realized, I don't want to like that your installation may have some problems.  :D
Title: Re: SQL tool?
Post by: emanuele on June 10, 2017, 06:02:02 am
LOL
Title: Re: SQL tool?
Post by: ahrasis on June 12, 2017, 11:26:21 pm
Lol...
Text only | Text with Images