Hi all,

I am very confused finding a database program equivalent to the Microsoft access under linux!!!

What are all those databases MySQL( online databasa only?!!!)
and IBM DB2 (commercial with a developer version free)!!!!!!!!!!

I am very confused here, I need it for a personal project to prepare for my study.

Your help would be soooooo much appreciated

Thx

MySQL IS NOT ONLINE only
i have it installed, and i develop applications that make use of it without being connected to the net!

What are you trying to do exactly ?

Hi all,
Thx uniball for your quick reply. I am trying to design a database for contacts (name, phone, address,.....) and link each contact to a detailed sales/payment transactions file for each contact.
It seems to be easy under access (even without courses :) ) but I think that SQL needs a lot knowledge (or it is just the name :D )
And are there any e-books available to learn about it (or about databases under liunux in general)???
BTW, yesterday I tried OpenOffice with the so called data sources and I still have a headack for trying to link the files with so poor (free) documentation.

actually SQl isn't that hard to learn

their are 3 Databases ( and i mean gooood databases ) available under linux for free

--as uniball said -- mysql

http://www.mysql.com/

this is the site

books ( you don't need them ) the manual for it is very easy actually and it's a very good database server.


second sol postgresql

http://www.postgresql.org/

this is the closest thing to microsoft sql it has internal quries and functions close to that of MS sql


third sol

which i think is the best sol for your case as you are searching for somthing like access ( unfotunately its still beta ) but i think it can do the job is staroffice 6.1 Base (database client)

you can download it from here
http://wwws.sun.com/software/star/staroffice/beta/

i hope i helped .........


:) :)

I'm really sorry, I intended to post more details, but my study "and some other problems" are eating most of the time.

I know that you can link MySQL and OpenOffice, and use them as you do with access.
but i don't know any details

SQL is very easy. the basics are
SELECT Retrieve a record
INSERT Insert a new record
UPDATE Update a record
DELETE Delete ;)
I'll try to post more details.

since your data is already in files, and you don't intend to move them, why use a database at all, keep the contacts in seperate files and search through them using grep org gnome find or whatever.

here is what you could do
have a directory called contacts
then make a file for each contact or for each group of contacts, the file should look somthing like

name: foo
phone: 100
address: fubar
etc.
transaction_file: foo.trans

name the file by the contact name or in anyway you like, the best thing about this is that you can be very free form about it, you can group more than one contact in one file, give the files random names whatever.

when you need to find the file for foo, just do
grep foo contacts/*

or even better split contacts into hierarchies with different directories, and use rgrep to search recursivle

to see the whole info for foo you can do
grep -4 contacts/* foo
this will print the 4 lines before and 4 lines after the record.

if you stick to a trict form for your contact files, you can even easily write a few scripts to find whatever info you need and print it, for instance getting the address of foo is as easy as

grep -C4 foo | grep address:

cheers,
Alaa

Hi again,

I would like to personally think each one of you for the his help.

linuxawy1980, Thx ery much for the links and the related info, you are a great help in my case ;) .

uniball, I think that your words gies me more confidence to go in the SQL world :D .

And alaa, well, this idea is great, really.
I just have no idea about the commands :D . Also, I will need to organize the files in such a manner to be able to maintain them.

Anyways, I think I will go the SQL through the MySQL first and see what would happen to me :rolleyes:

One little thing, I really hate how OO is acting on my PC, it is very HEAVY for my poor PC :confused: .takes too much time to open under KDE, and vanish as soon as it appears under GNOME!!!
Even right clicking on any window gives me the eeling that I am torturing my PC!!!:o

I hope that the new 1.1 is better (as it is said) from the performance point of view.

and StarOffice 6.1 , well, huge download for me :D . would the Base be aailable under OO soon?!!

Thank you all again ;)

welcome


but i am sorry to say no the base application won't be available to open office at all it's closed source.......


but you can use the open office to directly link to my sql and it's really easy SQL is very very easy and if you neeed any help just askkkkkkk:)

Hi there,

OK, I think I am going to quit computers at all

I get very stupid errors at the very beginning!!!!!!!! on MySQL I cant start the serer asasan!!! get error 2002 and tells me that whatever .sock is not working or so!!!

same with PostgreSQL I can't start the server and get a nother error there!!!!!!!!!!!!

I know, you wan't to know a detailed describtion of the errors, but I am in a rage right now, I think that my PC is very lucky that it is still sitting ON my desk!

I followed a tutorial to connect OO with MySQL, and failed right from the beginning!

I realize that the version is newer than that of the tutorial, but would it cause all that hasle?!!!!!!!!

I am installing the Access on the Windoze again!!!

I wish that I could find the solution myself, but it is over 7 hours in front of my stupid PC trying to know why it is complaining.

brb, as soon as I calm down.

for the StarOffice, I am sorry to know that

well let's take it one step at a time


here is what you need to really and easily work with sql


mysql server and manual from the link i posted before...

phpmyadmin


thats the easiest way to manage the mysql server once it is started.


http://www.phpmyadmin.net/

and of course to start the mysql once you finish downloading and ready to starting the server give post a message...

waiting ....

best regards ( and by the way never lose hope it might be a very small thing that is stoping you ..... think again quitly and you will find the sol )

and of course don't forget the miracules wizard that solves every thing ( if you can't ............. ask...)
:)

No please don't use access.
Please provide more details. Your distro. and version, the command you are issuing, the exact error message
if your error is like this:
http://forums.devshed.com/archive/4/2002/08/3/41797
try one of the following:
/etc/init.d/mysql start
or /etc/rc.d/init.d/mysql start

Originally posted by \\//\\//AHIB
Hi there,

OK, I think I am going to quit computers at all
...

I wish that I could find the solution myself, but it is over 7 hours in front of my stupid PC trying to know why it is complaining.
...



7 hours :mad:
sehhhh ven hours :mad:
ya3ni a3mel eih ya3ni , armee nafsee mel shebak !!!

i need 7 hours to wake up and start being usefull
ya dude , ool 6 months ... mesh 7 hours

seriously , and programming with files is actually harder

you need something like 2 years to be a real programmer

databases alone 6 month
be real man
7 hours doola, wala 7aga , wala ay 7aga khaless

wala 7ata ma3a access
access is a very capable database
and it's the undesputed king of it's niche

webattack.com uses access !!!

bass of course postgresql have all the other advantages of a free open source software

you get more for less !!!

bass 7 hours meen
enta keda bet3a2ad nafsak mooooooot

law ay 7ad alak eno u can learn sql in less then 2 months seebak meno tamaman
wala tekalem ma3a ba3d keda

maho el donia mesh khan2a awee keda

the first application i used sql in took me 20 days to develop and i learned sql during the development...............


yes getting the programming sense took me more than 2 years but after that it's just the matter of syntax but the concepts are the same in every thing :)


at least dah ra2yeeey

Hi again,

Thx for your support here all, ok, Have I said that I wanted to learn SQL in 7 hours?!! Sometimes I feel stupid, true, but not THAT stupid though ;) .

Anyways, the problem is that I couldn't start the server aslan. ( I am working in conjunction with a tutorial of using MySQL with OpenOffice proided by the MySQL site!!!

uniball, yes, it is very similar (same 2002 error). I'll try your solution and give you a feedback.

:D , I must tell you that my C drive (in windows) has around 6 or 7 MBs of free space :D . no access can be installed there I think ;)

Thx all, will be back ISA.

Mr. uniball,

I think that your method worked for me :D ,thx man.
One small thing to ask about, I can only start MySQL while I am the root, why?

And how can I start the MySQL without using the path you provided? typing MySQL ;) I need the symbolic link or whatever, coz I can't remember the path each time.

Thx guys for your helpful hints, I think I will be starting to get it working with OO now ;)

See ya.

You have to start it from a root account, That's a daemon, it has to log the errors for example to log files, those files are readable by root only as they may contain some sensitive information about the system
On debian there is start-stop-daemon which may be used to start daemons, but i don't use it and don't ask me why ;)
i think there should be an equivalent in mandrake.
you can create a shell script and put the command into it, you can even start mysql at boot time ;)