Friday, November 7, 2008

What is the purpose of the following files having extensions: frm, myd, and myi

What is the purpose of the following files having extensions: frm, myd, and myi? What these files contain? In MySQL, the default table type is MyISAM.Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type.The '.frm' file stores the table definition.The data file has a '.MYD' (MYData) extension.The index file has a '.MYI' (MYIndex) extension,
at
Labels: , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to solve mysql ERROR 1118 (42000) Row size too large

  I had this issue with MYSQL 5.7 . The following worked althoug...

  • Securely Communicating with Remote Servers via PHP
    PHP  has an  SSH2  library which provides access to resources (shell, remote exec, tunneling, file transfer) on a remote ma...
  • AWS important questions
      Which pillar of the AWS Well-Architected Framework recommends maintaining infrastructure as code? Operational Excellence Which of the foll...
  • Introduction to PHP PDO
    Introduction to PHP PDO (PHP Data Objects) 1. What is PDO 2. What Databases does PDO support 3. Where do I begin? 4. Connect to ...