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