Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
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.)
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.
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.
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?
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.