[opensuse] MySQL GUI frontends
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions? Happy Christmas :) -- Bob openSUSE 10.3, Kernel 2.6.22.13-0.3-default, KDE 3.5.8 Intel Celeron 2.53GB, 2GB DDR RAM, nVidia GeForce 7600GS -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
rekall - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHbut0tTMYHG2NR9URAk7mAJ9SqalGYXI1rFmouxivgn0I+9cBywCgg6dm Az9vNNdbX3KAFs/m0lG/f9k= =4EhH -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Carlos E. R. wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
rekall
I think it's pretty funny how that name can conceivably be pronounced as either "recall" or "wreck-all" -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 23 December 2007 23:12:50 Carlos E. R. wrote:
The Sunday 2007-12-23 at 22:23 -0000, Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
rekall
Thanks. Rekall seems to fit the bill, and is easy to set up. I'd previously tried OOo Base, but it seemed to want to recreate the database in .odb format, whereas Rekall is using the same MySQL tables, so I can administer the database from the command line or through the Rekall GUI. Knoda seemed to have the same problem as Base. Thanks to everyone for all the other suggestions. Happy New Year :) -- Bob openSUSE 10.3, Kernel 2.6.22.13-0.3-default, KDE 3.5.8 Intel Celeron 2.53GB, 2GB DDR RAM, nVidia GeForce 7600GS -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Wednesday 2007-12-26 at 10:52 -0000, Bob wrote:
rekall
Thanks. Rekall seems to fit the bill, and is easy to set up. I'd previously tried OOo Base, but it seemed to want to recreate the database in .odb format, whereas Rekall is using the same MySQL tables, so I can administer the database from the command line or through the Rekall GUI. Knoda seemed to have the same problem as Base.
Thanks to everyone for all the other suggestions.
OOo should be able to connect to an existing database, although setting up OOo to use mysql (or any other engine) is far from trivial. Knoda I haven't been lucky using it. In previous versions it crashed or didn't display what I wanted, etc, etc. Rekall has a fast and very easy to use interface, either for database design or use; plus you can use it with mysql, postgres, etc. - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHcroOtTMYHG2NR9URAscUAJ4mTOoiOv0QAaTsmdgdJTc+GV19oQCeMKZh ZoE4xbnS/tB/NFC2APiHZUQ= =heEQ -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Happy Christmas :)
Good evening Bob, You could do worse than looking at either phpmyadmin - http://www.phpmyadmin.net/home_page/index.php or MySQL Administrator - http://dev.mysql.com/downloads/gui-tools/5.0.html I tend to use phpmyadmin on my remote servers, with a strong password and an obscured path. Mysql administrator is good for workstation work locally where I have a GUI. Have a look at both and see what you prefer. Have a great Christmas and a happy new year. :) Cheers Pete -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 23 December 2007 14:23, Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Several: I use most often - since there's very little install - phpMySQL. It comes with openSUSE and runs in Apache. There's also the MySQL Administrator. Both of those come with openSUSE and can be loaded via YaST or SMART or whatever you tool of choice is. I've had good luck with the MySQL tools as well: http://dev.mysql.com/downloads/gui-tools/5.0.html HTH! -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 23 December 2007 23:23:58 Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
tora is quite popular http://tora.sourceforge.net Anders -- Madness takes its toll -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Anders Johansson wrote:
On Sunday 23 December 2007 23:23:58 Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
tora is quite popular
Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it? Joe -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Monday 24 December 2007 00:48:17 Joe Sloan wrote:
Anders Johansson wrote:
On Sunday 23 December 2007 23:23:58 Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
tora is quite popular
Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it?
I've used it with mysql. Admittedly, I'm not really a DBA, so I haven't used it for much more than simple stuff, but it seems to work well enough for that. I know it was written for Oracle, but it does work with mysql. But as I said, I'm no DBA, so I'm not a good judge of what's great or not Anders -- Madness takes its toll -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 23 December 2007 15:48, Joe Sloan wrote:
Anders Johansson wrote:
On Sunday 23 December 2007 23:23:58 Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
tora is quite popular
Great for oracle, but useless for mysql or any other rdbms last I checked - or have they done an extreme makeover on it?
I'm trying to install but it wants to have me download a "basic" package that is only availble through a registered login at the oracle site.... -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Happy Christmas :)
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.) Don Henson -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Monday 24 December 2007 02:21, Donald D Henson wrote:
Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Happy Christmas :)
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)
That looks great, but.... ...how does on install VS2005 in Linux? :P -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Mon, 2007-12-24 at 03:21 -0700, Donald D Henson wrote:
Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Happy Christmas :)
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)
Don Henson
I'd like to check it out...but their site only has a windoz version, no LINUX until 2008... Tom in NM -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Dec 24, 2007 3:26 PM, Tom Patton <thpnalb@micro-net.com> wrote:
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)
Don Henson
I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...
Tom in NM
Check for package mysql-gui-tools on download.opensuse.org. It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck Cheers -- Svetoslav Milenov (Sunny) Even the most advanced equipment in the hands of the ignorant is just a pile of scrap. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tue, 2007-12-25 at 08:27 -0600, Sunny wrote:
On Dec 24, 2007 3:26 PM, Tom Patton <thpnalb@micro-net.com> wrote:
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)
Don Henson
I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...
Tom in NM
Check for package mysql-gui-tools on download.opensuse.org.
It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck
Cheers
-- Svetoslav Milenov (Sunny) Thanks, Sunny, I had overlooked the workbench when installing from the dvd's, I thought it was the "benchmark"...it is a separate rpm "mysql-workbench" on the dvd.
It installed 1.1.10alpha, and indeed looks very promising. I'll look some more for the beta version. Merry Christmas...or whatever is appropriate for you. Thanks! Tom -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tuesday 25 December 2007 06:27, Sunny wrote:
On Dec 24, 2007 3:26 PM, Tom Patton <thpnalb@micro-net.com> wrote:
Check out Mysql Workbench (http://dev.mysql.com/workbench/). It's still in beta but it's a good beta. (Disclaimer: I'm not a dba either.)
Don Henson
I'd like to check it out...but their site only has a windoz version, no LINUX until 2008...
Tom in NM
Check for package mysql-gui-tools on download.opensuse.org.
It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck
I have that installed - but there's no query browser or workbench that I can see. How do I run them? OT - i wish the RPM database showed what the executable(s) for an application or package was. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
Kai Ponte wrote:
I have that installed - but there's no query browser or workbench that I can see.
How do I run them?
Mine showed up as 'Database Query Tool' in 'New Applications.'
OT - i wish the RPM database showed what the executable(s) for an application or package was.
Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-12-25 at 23:46 -0800, Jerry Houston wrote:
OT - i wish the RPM database showed what the executable(s) for an application or package was.
Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables.
Only after they are installed. Or, you can use "pin", which will show them "before" and "after". - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHcjQNtTMYHG2NR9URAlBSAJwLIRIOayWbL9rAMvEgPJ6F41ONbwCeKAYb kDogQW44Y1WevGIzaat2SAs= =Xv0M -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tuesday 25 December 2007 23:46, Jerry Houston wrote:
Kai Ponte wrote:
I have that installed - but there's no query browser or workbench that I can see.
How do I run them?
Mine showed up as 'Database Query Tool' in 'New Applications.'
ahh, new applications - that is very nice. Actually another post clued me in. Turns out there is a seperate mysql-queryworkbench rpm to install.
OT - i wish the RPM database showed what the executable(s) for an application or package was.
Use the YaST software installation module, and it will list the files that are part of a package, and where they are placed on your system. Some of them display in bold type -- I'm guessing those are the executables.
Bold. Got it. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 The Tuesday 2007-12-25 at 08:27 -0600, Sunny wrote:
Check for package mysql-gui-tools on download.opensuse.org.
It contains mysql-admin, mysql-query-browser, and ... mysql-workbenck
They are separate packages now. ] mysql-workbench - A MySQL visual modeling tool ] ] MySQL Workbench is modeling tool that allows you to design and generate ] MySQL databases graphically. ] MySQL Workbench requires OpenGL and a 3D accelerated graphics card with ] at least 16MB of memory. Why does it need that? It is the first time I see an "office" tool needing heavy graphic resources :-O :-/ - -- Cheers, Carlos E. R. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.4-svn0 (GNU/Linux) iD8DBQFHdOBltTMYHG2NR9URAkFaAKCUKZEpOIM42VMCYN1SxtjuJR9RvgCfWXjr HkCWUY2iOOpf7+Lze4oBhEs= =z4oc -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sunday 23 December 2007 22:23:58 Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Hi Bob I have used phpMyAdmin and knoda and found both to be acceptable Merry Christmas -- Kind Regards, Ritchie ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Ritchie Fraser Web: http://www.rpfraser.uklinux.net Registered Linux User #255860
Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
Happy Christmas :)
Also, if you use Eclipse already for anything I know I have tools installed for MySQL and databases in general. Can't remember if they are plugins or came with the platform SDK. I can look let you know if you are interested. Merry Holidays --Jason -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Sun, Dec 23, Bob wrote:
I've played around with MySQL on the command line, creating an addressbook database and importing some data. I'd like to use a GUI frontend to add/edit the data, but I'm not sure what's available in linux. Any suggestions?
sqldeveloper from oracle, dbvis (google it). You'll need to find and install the java mysql code, usually called mysql-connector-java-X.X.X.tar.gz for either of the above. sqldeveloper seems more powerful generally, but dbvis has a nifty graph view based on foreign keys. Nice to see what depends on what. Michael "who has never been able to build a mysql gui pkg from mysql" -- Michael Fischer michael@visv.net -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (14)
-
Aaron Kulkis -
Anders Johansson -
Bob -
Carlos E. R. -
Donald D Henson -
Jason Craig -
Jerry Houston -
Joe Sloan -
Kai Ponte -
Michael Fischer -
Pete Connolly -
Ritchie Fraser -
Sunny -
Tom Patton