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).

Re: How do I use mySQL?
 

Hmmm, i did not realise there are no package made for this application.

you can type the following to get the content of the archive:

tar xvzf sqlite3sg-2.0.1.tar.gz

It seems this is not fully polished yet, so i'm not sure it will fit your need.
There is a README file that gives some information on how to use it, but as it is not packaged you will most probably have to install several dependencies manually (sqlite3 of course, but python2.5 and glade too).

sqlite3 is like mysql but is smaller and so more adapted for small devices.

Reading a bit about sql (mysql,postgresql or sqlite) is definitively a good starting point :-)

Good luck.

Re: How do I use mySQL?
 

You don't have to pay for an account.

No. MySql is a database engine that runs on your machine, like mssql or oracle.
As such, as a user you cant actually *do* anything with it like you can with access or those sort of programs. You need another application to use it (or a website etc). mysql is often used as the back of a shopping website.

I think from what you have said so far that it is really not the sort of program you are looking for.

However, if I am wrong, and you have it installed on your IT, the only way to access it unless you have some GUI is to access it in a terminal.
Here is something I found which might help.

Re: How do I use mySQL?
 

Thank you and everyone that has helped me decide what app to go with. I now have a good idea how mysql works. I think I am better off going with a local database such as glom just because it was made very similar to MS Acess which is what I am used to. Now if I could only get it installed. lol:D