CODEWITHSUNDEEP
mysql
Nano
Nano

Reputation: 196

.frm .MYD .MYI 1 file have 3 different extension

Why some table have 3 types of files and some doesn't.

If i remove one of them what will happen

If I have one table call admin.sql

CREATE TABLE `admin_assert` (
  `assert_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Assert ID',
  `assert_type` varchar(20) DEFAULT NULL COMMENT 'Assert Type',
  `assert_data` text COMMENT 'Assert Data',
  PRIMARY KEY (`assert_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin Assert Table';

How can I encode this .sql file to .frm .MYD .MYI extensions manually?

Upvotes: 0

Views: 3841

Answers (1)

Aman Aggarwal
Aman Aggarwal

Reputation: 18459

you can't covert this sql file to these three files manually.

These three formats- .frm .MYD .MYI represent that the table is in MyISAM. It represents structure file, data file and index file.

The rest of tables are in some another engine probably Innodb that have .ibd and frm files.

You can convert your sql file to these three files by:

First create the table. Alter the table by command=> ALTER TABLE table_name ENGINE='MYISAM'; Then you can see three files..

Upvotes: 2

Related Questions