SQL tool? April 24, 2017, 01:43:38 am At work I am using 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 ) 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?
Re: SQL tool? Reply #1 – 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.
Re: SQL tool? Reply #2 – 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.
Re: SQL tool? Reply #3 – April 24, 2017, 07:49:37 am I use Adminer its a single file PHP based database manager.
Re: SQL tool? Reply #5 – April 24, 2017, 01:43:57 pm Huh, that's awesome. I'd never even heard of it.
Re: SQL tool? Reply #6 – 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
Re: SQL tool? Reply #7 – April 25, 2017, 12:57:42 am Toad costs more than 1.000 Euro as basis installation. Too much for a hobby.
Re: SQL tool? Reply #8 – April 25, 2017, 01:28:04 am Quote from: Spuds – April 24, 2017, 07:49:37 amI use Adminer its a single file PHP based database manager.Looks perfect! Thanks!
Re: SQL tool? Reply #10 – April 25, 2017, 05:02:18 am Quote from: Jorin – April 25, 2017, 12:57:42 amToad 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 – April 24, 2017, 03:32:19 pmFound at https://www.quora.com/What-is-the-best-MySQL-client-for-Mac-OS-X-or-WindowsAnd what inter mentioned as well.
Re: SQL tool? Reply #11 – April 25, 2017, 10:22:21 pm Quote from: Spuds – April 24, 2017, 07:49:37 amI use Adminer 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.
Re: SQL tool? Reply #12 – June 08, 2017, 03:00:59 am Thanks for the information, @ahrasis. No problem for me though...
Re: SQL tool? Reply #13 – 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.
Re: SQL tool? Reply #14 – 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.