Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1302
  • Last Modified:

.SQL and .frm files

Hi,

Can anyone tell me the difference between a .sql files and a .frm with regards to mysql databases and the tables within? Is it anything to do with running mysql on a linux or windows machine?


Thanks,
Suzy
0
fyness
Asked:
fyness
1 Solution
 
Jay ToopsCommented:

.frm Table definition format files
.sql  Files are simply ascii files that contain queries.

File  Purpose  
`tbl_name.frm'  Definition (format) file  
`tbl_name.MYD'  Data file  
`tbl_name.MYI'  Index file  

This came from the mysql manual
which can be found at http://dev.mysql.com/doc/
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now