View Full Version : MySQL??? What is it?


darklitch
02-19-2005, 06:30 PM
I know MySQL is something to do with databases, but where can i get some practice with MySQL? Do you need to put it in a cgi-bin?

pb&j
02-20-2005, 05:13 AM
cgi-bin goes with Perl coding.
MySQL is a database.
two seperate things.

to use MySQL, your host will have to support and supply it for you.

many people use PHP coding to interact with the MySQL database to store and retrieve information.

darklitch
02-20-2005, 01:52 PM
what is the file extention for MySQL?

webgirl
02-20-2005, 02:08 PM
what is the file extention for MySQL?
It's a database so would it have a file extention?

darklitch
02-20-2005, 02:31 PM
It's a database so would it have a file extention?
It has to be stored some where

pb&j
02-20-2005, 03:06 PM
its kinda more of an application, so it really does not have an extension. kinda like if Windows would have no extension... its just there.

if you did a "dump" which basically creates a backup of your database "file", then i think the extension for that would be "sql". cant recall, been too long since ive done one.

if your host provides MySQL, then just do a quick search for some tutorials on it and things may become a bit more clearer.

jpjfleafreak
02-20-2005, 03:51 PM
i use sql combined with php to take information from forms and put it in an access database. that's pretty much what it does, you can take user inputted information and put it in a database, and you can take information from the database and put it on the page.

bejayel
02-20-2005, 07:47 PM
www.3dbuzz.com has some beginner mysql ideo tutorials. And yes, they dump as .sql. When you actually go intot eh database and look at the files, you get the database name as a folder and the files that store the seperate tables in a database are jsut files with a blank ending.

briankircho
02-22-2005, 06:00 AM
In case anyone was interested, theres accually 3 files created for each Mysql table. If you have a table named users in database test then

users.frm
users.MYI
users.MYD

they would all be in the test/ folder where the database stores its files on the server :)

bejayel
02-23-2005, 04:37 PM
hmm i though that files with no extension were created... I guess i havent looked there in a LONG time. I was probably thinking of something else.