GUIs for MySQL 4.0.18 under Mandrake 10.0?
 

Hi all,

I have MySQL 4.0.18 installed under Mandrake 10.0, and find myself trying to create a database which is a bit bigger than a toy: at least two tables would have six or seven hundred records each. Using the command line interface to add records one by one is obviously impractical, but not being a gifted scripter, I have found it more laborious than expected to put the raw data in a file and then read in the file as described in the MySQL manual. Somewhere I saw a hint that Open Office Base provides a GUI for working with MySQL. Does anyone have any experience with that? I have been unable to find Open Office Base at the Debian archive and I don't seem to have it in my set of Mandrake CDs. Any suggestions?

Alternatively, does anyone know if there another good GUI for MySQL for which I can find something like an rpm on the web? (I am probably not up to make/install unless someone were willing to talk me through the process.)

TIA, Peufelon

just install openoffice and openoffice base will come for free

Apparently not true for Mandrake 10.0 or another linux distro I tried. They both came with Open Office Writer and some other pieces of the OO suite, but not with Open Office Base (very possibly I somehow munged something during installation, but if so I can't figure out how to fix it).

I can't find Open Office Base at the debian repo nor can I find it on the Mandrake system disks I bought.

Peufelon

have you tried the linux installer at openoffice.org?

Well, now, this is interesting. My dpkg "broke" just about the time that there was that big change in /etc/apt/sources.list and I never quite got that right. Just tried again with the example from the MEPIS wiki and was able to update the database of available packages and this worked. Emboldened, I tried upgrading a few things and it worked! Right now I am trying to install mysql-admin and mysql-query-browser. On first try it stopped with error 130 but I think that just means my fragile(?) dial-up connection was dropped, so I just tried again and so far so good.

Sorry, fraz, let me explain the cryptic reference: at some point there was confusion for some MEPIS users because some change at the Debian archives required MEPIS to have to change their recommended /etc/apt/sources.list sooner than expected. I was thrown by comments forbidding user from altering the list, contrary to instructions at MEPIS forum. But what happened today was that I ignored the alarming comments and just overwrote my /etc/apt/sources.list (keeping a backup copy of course) and tried to install some stuff, and so far it looks like this may actually have unbroken my dpkg. This would be highly desirable even though I plan to do an upgrade shortly.

If this works I will upgrade to mysql 5.0 which I wanted to do anyway. In my previous posts I was actually talking about mysql 4.0.18 on my other machine, which is a separate problem since I don't download anything from the web onto that machine.

Try phpmyadmin: http://www.phpmyadmin.net/home_page/index.php

Thanks, Chris, I'll look into phpadmin.

Right now it seems that if I can succeed in installing mysql at all in a Debian-derived distro (I've had problems, possibly because I broke something to do with apt), mysql-admin and mysql-query-browser packages at Debian archives might be a bit safer for a newbie.

But I'd still be happy to hear other possibilities if anyone has any to share! Right now I am not planning to offer access to the database to anyone else, but at some point I would like to play with php and mysql in a safe environment. Does anyone know a good book for writing safe php code in a linux environment, incidently?