what is extension of files of mysql?
2006-12-18 16:17:34 · 4 answers · asked by far 1 in Computers & Internet ➔ Programming & Design
I dont really understand this question.
MYSQL is a database and as such when you deal with databases there are two kinds of files you could be talking about
1- The input files : These files can either be .sql files in which you place your statements or you could load data into your database via the " LOAD DATA INFILE" command, for which the file extension is immaterial (I think)
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
2- The output files: Here again you could mean two things
a) The output from a SQL select command could be directed to a file by the "OUTFILE" sysntax, for which the file extension is immaterial (I think)
http://dev.mysql.com/doc/refman/5.0/en/select.html
b) The internal datadump files used by MySQL, in which case they would be .MYD, .MYI etc extensions. I strongly advise you to not mess around with those files to preserve data integrity
2006-12-18 16:39:11 · answer #1 · answered by Neil 5 · 0⤊ 0⤋
There are many extensions for mysql, some are given below
frm, arm, cnf, dbs, myi, myd, mrq, opt, phl, sql, arz, sal
2015-09-20 21:11:04 · answer #2 · answered by Tom 2 · 0⤊ 0⤋
database files consist of .MYI .MYD .frm
2006-12-18 16:40:41 · answer #3 · answered by Anonymous · 0⤊ 0⤋
frm, myd, myi etc
2006-12-18 16:30:58 · answer #4 · answered by tasdiqahmed 2 · 0⤊ 0⤋