LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This 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


Reply
  Search this Thread
Old 04-07-2006, 03:55 PM   #1
Peufelon
Member
 
Registered: Jul 2005
Posts: 164
Blog Entries: 1

Rep: Reputation: Disabled
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
 
Old 04-08-2006, 05:06 PM   #2
fraz
Member
 
Registered: Nov 2004
Location: Edinburgh, Scotland
Distribution: Ubuntu
Posts: 149

Rep: Reputation: 15
just install openoffice and openoffice base will come for free
 
Old 04-08-2006, 05:28 PM   #3
Peufelon
Member
 
Registered: Jul 2005
Posts: 164

Original Poster
Blog Entries: 1

Rep: Reputation: Disabled
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
 
Old 04-08-2006, 05:37 PM   #4
fraz
Member
 
Registered: Nov 2004
Location: Edinburgh, Scotland
Distribution: Ubuntu
Posts: 149

Rep: Reputation: 15
have you tried the linux installer at openoffice.org?
 
Old 04-09-2006, 05:52 PM   #5
Peufelon
Member
 
Registered: Jul 2005
Posts: 164

Original Poster
Blog Entries: 1

Rep: Reputation: Disabled
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.
 
Old 04-09-2006, 06:03 PM   #6
Peufelon
Member
 
Registered: Jul 2005
Posts: 164

Original Poster
Blog Entries: 1

Rep: Reputation: Disabled
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.
 
Old 04-09-2006, 09:15 PM   #7
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Rocky 9.2
Posts: 18,349

Rep: Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750Reputation: 2750
Try phpmyadmin: http://www.phpmyadmin.net/home_page/index.php
 
Old 04-10-2006, 05:16 PM   #8
Peufelon
Member
 
Registered: Jul 2005
Posts: 164

Original Poster
Blog Entries: 1

Rep: Reputation: Disabled
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?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
GUIs besides X? pentalive Linux - General 9 02-04-2006 02:31 AM
GUIs juvestar15 Linux - Newbie 5 09-10-2005 06:15 AM
Different Users - Different GUIs mikefromau Slackware 3 02-06-2004 07:17 AM
How do you write GUIs for C? linuxfond Programming 3 09-03-2003 01:48 PM
GUIs Jed Linux - Newbie 1 08-09-2003 04:14 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:54 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration