How do I use mySQL?
 

I have installed mySQL but have never used it before. I was hoping to use it as a database program on my N810 for my business.

Here are a few of my questions regarding mySQL:

1. Shouldn't it be listed in the program list?...I cannot find it there.

2. Could someone breifly explain how mySQL works?

3. Am I wrong in thinking this could be used as an alternative to glom?

4. Do I need an account setup on an mySQL server or can I use it locally? If that makes any sense.

Any help would be appreciated.

Re: How do I use mySQL?
 

1. no, you'd run the MySQL server from the command line (or have it start up automatically)

2. it's a database. it allows the computerized storage and retrieval of information.

3. i don't know what "glom" is, so i cannot compare/contrast the two

4. yes, you'll need an account to log in. both server and client can reside on the same machine, or on different machines.

It sounds like you were looking for some sort of application to do your 'business tasks' with -- think of a database as an 'engine' in a car: with just an engine, you cannot drive anywhere - you need the rest of the car (the application). Then, you may need tools (knowledge of programming, SQL, etc.) to either build the car (application) or to keep it tuned up.

A database, by itself, will not do anything except take up some space on your computer. It sounds like you probably want some sort of business application that uses MySQL (or any of several alternative) databases for storage/retrieval... and specifying, designing, building, debugging (and so on) of a database application is well beyond the scope of this forum.

Re: How do I use mySQL?
 

Hi there.

I wonder if what you are looking for may be this:

https://garage.maemo.org/projects/sqlite3sg


It is a simple GUI to access sqlite3 database.

Re: How do I use mySQL?
 

Brian, thanks for you reply. Very good assimilation of what a database is. I guess I am looking for a simple database without having to pay for an account. I have set up a few of my own databases in Windows XP MS Acess and I am a computer desktop technician by trade but I was just curious about mySQL to see if it may be right for me. I think it would work for me but I am still a little unclear of the details. Does mySQL cost to get an account?

Glom is a database that I had a problem installing but would be willing to bet that it is exactly what I am looking for. If only I could install it and make it work on my N810 to find out. I was having trouble finding all the files needed to install it.

Re: How do I use mySQL?
 

Hmmmm... I will give it a try, thanks.

Re: How do I use mySQL?
 

Ricky --

No, you wouldn't need to pay to get an account. Once the database software is installed, you can create databases, namespaces, tables, and user accounts to your heart's desire. I would heartily recommend the O'Reilly books on MySQL if you're not familiar with SQL syntax.

Re: How do I use mySQL?
 

Incidentally Pamadio, I am a newbie to Linux and X-Term but could you show me how to extract the tarball in X-Term? I think I previously downloaded a decompression utility...I think it was bzip2 or something. Am I even close?

Re: How do I use mySQL?
 

Great now the only problem I am having is after the App manager said mySQL was successfully installed, I do not have any app to open. Am I missing a file or something? I installed the mysqldatabase file. Is there another file I need or a certain repository?

Re: How do I use mySQL?
 

if the App manager said it was installed, it's there.

it is not, however a GUI application, so there's nothing to be seen on the menu. how to start it up, and what to do once it's started, is covered in detail in the book(s) I recommended earlier...

Re: How do I use mySQL?
 

Excellent! Thanks for the info and all your help. I will definitely read your recommended book(s).