peter Nikolic wrote:

On Saturday 31 Jul 2004 23:29, Dalton Silva Ribeiro Filho wrote:

...

Anyone know a GUI where I can start MySQL Server?

I know MySQL Control Center and MySQL Query Browser but I still haven't found a GUI for MySQL Server - anyone know? Is there a package for it?

Thanks in advance.

Dalton

Any one know when we are going to get Dbase III Plus for Linux we might get a database that is useable then instead of one that is just a pain in the butt ..:-)..

Pete .

Going back many moons there was a web application that was that easy to use, then along came a change (glibc I think) in Linux that broke that app. Next it was yanked rather than upgraded. All the applications I've seen and I have tried many, demand you become a DB administrator familiar with sql language. It seems databases for the common man is not thought politic, so if you just want to enter and retrieve data and you can't structure queries, you're cornered. Someone suggested phpMyAdmin, great! It brings up a nice screen. As a simple exercise, you create a database and table, again great! Now you want to enter data into the fields, CHECKMATE! Funnily enough, you can more easily manipulate the database from the command line, but if you are a very occasional user, you have to go back and relearn the stuff you learned months ago as none of it is intuitive. It's like having to manually set the mixture, the timing, points gap and other stuff in order to get your engine running, hard luck if you left the manual and tools back at home. Going back to DOS, there were databases that were easy to setup and query, with no need to understand the internals. One colleague back then asked me if there was a sharware database I could recommend, I suggested one and he was instantly up and running, I don't think he or I knew what SQL was. I keep looking, but there is nothing available currently that fits that bill, nothing beyond a wrapper to displace the need for some typing. Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer =====LINUX ONLY USED HERE=====

Sid wrote regarding 'Re: [SLE] GUI for MySQL Server' on Sun, Aug 01 at 04:16:

peter Nikolic wrote:

Someone suggested phpMyAdmin, great! It brings up a nice screen. As a simple exercise, you create a database and table, again great! Now you want to enter data into the fields, CHECKMATE!

What? Click "insert" and up comes a page with text boxes that you put the data into. PHPMyAdmin isn't exactly a tool that any uninformed person can use, but entering data into a database is *not* one of the things it makes difficult. Actually, the query builder is pretty easy, too. You can't add pretty graphics to the background, but otherwise it's not difficult to use at all. It's a little hard to set up if you don't read the manual, but there again, learning is good... The newer versions can do *lots* of cool stuff.

Funnily enough, you can more easily manipulate the database from the command line, but if you are a very occasional user, you have to go back and relearn the stuff you learned months ago as none of it is intuitive.

Go to google. Type in what you're trying to do. Click the first few links. Maybe stick "site:mysql.com" in your query somewhere. If you're only doing it once every few months, that's not that big of a deal. :)

It's like having to manually set the mixture, the timing, points gap and other stuff in order to get your engine running, hard luck if you left the manual and tools back at home.

Next time, just remember that the mixture screws are usually backed about 1.5 turns from bottomed out as a starting point, and you usually want around 8-10 degrees initial advance, with maybe 30 or so total. Throw that points ignition away and get a modern elecronic replacement - costs about $30 US and is much less of a hassle than remembering a .065" point gap (setting dwell is more of a pain). ;) --Danny

Danny Sauer wrote:

Sid wrote regarding 'Re: [SLE] GUI for MySQL Server' on Sun, Aug 01 at 04:16:

...

peter Nikolic wrote:

Someone suggested phpMyAdmin, great! It brings up a nice screen. As a simple exercise, you create a database and table, again great! Now you want to enter data into the fields, CHECKMATE!

What? Click "insert" and up comes a page with text boxes that you put the data into. PHPMyAdmin isn't exactly a tool that any uninformed person can use, but entering data into a database is *not* one of the things it makes difficult. Actually, the query builder is pretty easy, too. You can't add pretty graphics to the background, but otherwise it's not difficult to use at all. It's a little hard to set up if you don't read the manual, but there again, learning is good... The newer versions can do *lots* of cool stuff.

I'm having to get used to it and making progress, but it's not as straightforward as the web tool of some years ago, that made mysql so much easier to handle, a piece of doddle it was as we say here. It seemed it was dropped simply because someone thought that with that tool, DBA's jobs weren't safe.

...

Funnily enough, you can more easily manipulate the database from the command line, but if you are a very occasional user, you have to go back and relearn the stuff you learned months ago as none of it is intuitive.

Go to google. Type in what you're trying to do. Click the first few links. Maybe stick "site:mysql.com" in your query somewhere. If you're only doing it once every few months, that's not that big of a deal. :)

...

It's like having to manually set the mixture, the timing, points gap and other stuff in order to get your engine running, hard luck if you left the manual and tools back at home.

Next time, just remember that the mixture screws are usually backed about 1.5 turns from bottomed out as a starting point, and you usually want around 8-10 degrees initial advance, with maybe 30 or so total. Throw that points ignition away and get a modern elecronic replacement - costs about $30 US and is much less of a hassle than remembering a .065" point gap (setting dwell is more of a pain).

;)

--Danny

Thanks, I think I can remember that. May be it's the years, an old guy used to tell a story -- an old guy once told him the first sign of old age was when three things started to go, the first was your memory, there were two other things he told him, but he couldn't remember what they were. Regards Sid. -- Sid Boyce .... Hamradio G3VBV and keen Flyer =====LINUX ONLY USED HERE=====

On Tuesday 03 August 2004 14:11, g.lams@itcilo.org wrote:

I hear also about DB Designer which seems to be nice ( http://www.fabforce.net/ )

gael

Looks great, but it needs libborunwind.so.6.0 Where do I get this one? bye Ronald -- Ronald Wiplinger Senior Software Engineer AGP Telecom Co. Ltd. Tel. (O) +886-2-2741-7890 # 7303, (M) +886-939-77-55-16 (from USA dial (408)253-3153 # 7303) -----------------------------------------Disclaimer------------------------------------------------------- This document is intended for transmission to the named recipient only. If you are not that person, you should note that legal rights reside in this document and you are not authorized to access, read, disclose, copy, use or otherwise deal with it and any such actions are prohibited and may be unlawful. The views expressed in this document are not necessarily those of AGP Telecom Co., Ltd. Notice is hereby given that no representation, contract or other binding obligation shall be created by this e-mail, which must be interpreted accordingly. Any representations, contractual rights or obligations shall be separately communicated in writing and signed in the original by a duly authorized officer of the relevant company. ----------------------------------------------------------------------------------------------------------

On Tuesday 03 August 2004 08:41, Ronald Wiplinger wrote:

On Tuesday 03 August 2004 14:11, g.lams@itcilo.org wrote:

...

I hear also about DB Designer which seems to be nice ( http://www.fabforce.net/ )

gael

Looks great, but it needs libborunwind.so.6.0

Where do I get this one?

That is a package mistake. AFAIK, that file should be provided in the rpm package. Cheers, Leen

In a previous message, Leendert Meyer wrote:

On Sunday 01 August 2004 00:29, Dalton Silva Ribeiro Filho wrote:

...

Anyone know a GUI where I can start MySQL Server?

I know MySQL Control Center and MySQL Query Browser but I still haven't found a GUI for MySQL Server - anyone know? Is there a package for it?

The best database front end for linux that I know of is Rekall (http://www.rekallrevealed.org/). This is a GPLed app that lets you create tables, forms, queries and reports suitable for desktop use, and uses MySQL as one of the possible back ends (PostgreSQL, dBase and others are also possible). It's based on the Qt toolkit (not a web interface) so should fit nicely into a SUSE KDE desktop. It's probably the easiest to use as an actual day-to-day database because its forms and reports are very good. I've been using Rekall for quite some time and it's excellent - it provides all the tools most people will need to replace Access or FileMaker Pro. It requires a certain amount of knowledge to use (i.e. you need to know the basics of relational databases) but the manual is OK and the mailing list can give excellent help. HTH John -- John Pettigrew Headstrong Games john@headstrong-games.co.uk Fun : Strategy : Price http://www.headstrong-games.co.uk/ Board games that won't break the bank Fields of Valour: 2 Norse clans battle on one of 3 different boards

In a previous message, steve-ss wrote:

On Sunday 01 August 2004 15:48, John Pettigrew wrote:

...

...

On Sunday 01 August 2004 00:29, Dalton Silva Ribeiro Filho wrote:

...

Anyone know a GUI where I can start MySQL Server?

You can use yast to start the mysql server.

To clarify my former post - the best way to *start* the MySQL server is, of course, simply to use the YaST runlevel editor and enable it for runlevel 5 (and any others you want).

I can't see how any other gui would help you to do so. I don't think any gui will ease the steep learning curve. In the end you'll have to type commands anyway so you may as well do that in text mode.

But the point of using Rekall (or whatever) is that it does completely insulate you from the command line. IIRC, you have to use it to create an initial database file in MySQL, but everything else can be done in Rekall - table creation, form design, data entry, querying, reporting - without using any SQL at all. John -- John Pettigrew Headstrong Games john@headstrong-games.co.uk Fun : Strategy : Price http://www.headstrong-games.co.uk/ Board games that won't break the bank Valley of the Kings: ransack an ancient Egyptian tomb but beware of mummies!

Søndag 01 august 2004 21:59 kvad Dalton S.R.F:

...

But the point of using Rekall (or whatever) is that it does completely insulate you from the command line. IIRC, you have to use it to create an initial database file in MySQL, but everything else can be done in Rekall - table creation, form design, data entry, querying, reporting - without using any SQL at all.

John

Well, I already know the sql syntax, I just wanted some easy way to initialize the sql server, like I did with the M$ SQL Server, where it was just a small button on the tray which I could turn on and off.

Dalton

Good evening Dalton, simply turning it on and off should be possible simply by activating/ deactivating it in the runlevel editor in YaST. The first activation should take care of proper initialisation. Best regards Johnny :o)