LinuxQuestions.org
Share your knowledge at the LQ Wiki.
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 07-24-2003, 02:22 PM   #1
luap
Member
 
Registered: Feb 2003
Location: atlanta ga usa
Distribution: suse 8.2
Posts: 78

Rep: Reputation: 15
mysql and staroffice


hi,
let me state first that i am just starting with mysql! and databases in general.
i have mysql and staroffice installed and working in gentoo.
i have the obdc(or whichever) driver set up, staroffice is connecting to mysql,
and i can access (sorry about that, but it was a good english word before it became a microsoft product)my mysql database(s).
i built my tables from command line, but inserted my records from
mysqlcc. i find inserting records from command line and mysqlcc sort of clunky, so i thought i'd try thru staroffice.however, i find that with staroffice i can edit my tables, but i cant insert records .
i did some reading in the latest staroffice how to book, and found a blurb or two about this problem being due to 1)permissions
2) primary key or 3) staroffice not being able to insert records in to tables done in other apps! well, 1) my mysql user id is passworded, staroffice asks for and recognizes the user/password(there is only one user) and, since i can edit my tables, it seems to me that this wouldnt be the problem. 2) i set primary keys on my tables when i built them, and in staroffice table edit mode, the primary key symbols are present. so, is it
3)? if so, can anyone provide me with a nice gui frontend for mysql that is good for fast data entry of tons of records? or because i am a mysql newb numbno, should i be using a spreadsheet or editor to record data, and then do some kind of import in to my mysql tables? i am doing up my music cd collection as a database, to catalogue and use for query practice,
so my data is mostly text, but does include track #'s and track length in time format. any suggestions welcomed, any flames will be read and voodoo dolls made for the senders.
 
Old 07-24-2003, 06:44 PM   #2
dkaplowitz
Member
 
Registered: Oct 2002
Location: Havertown PA
Distribution: Ubuntu/RHEL/Fedora
Posts: 253

Rep: Reputation: 31
Have you checked out phpmyadmin? It's a web based gui front-end for MySQL (runs of your local apache). It's very easy to install and will allow you to either add a huge .sql file in one shot, or will allow you to run individual SELECT statements. It's a pretty sweet tool to use.

Here's a URL you can use to download it: http://sourceforge.net/projects/phpmyadmin/

There are a million more gui front-end tools for MySQL....there are other posts on this board about them.
 
Old 07-24-2003, 10:55 PM   #3
luap
Member
 
Registered: Feb 2003
Location: atlanta ga usa
Distribution: suse 8.2
Posts: 78

Original Poster
Rep: Reputation: 15
hi thanks for the suggestion- maybe i'll try it, but i'm not running an apache server, dont really want to. my foray in to mysql is strictly a localhost thing.
i'll try refining my search here and see what i come up with.
 
  


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
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
StarOffice 5.2 hank@$3800 Linux - General 16 06-18-2002 09:08 PM
Staroffice 5.2 Notfromkansas Linux - General 7 05-30-2002 01:25 PM
staroffice KevStA Linux - Newbie 4 05-29-2002 09:48 PM
staroffice athenerx Linux - Newbie 2 03-22-2002 12:17 PM


All times are GMT -5. The time now is 08:46 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration