How Do I Convert ISAM Tables to MyISAM Tables?

Author Topic: How Do I Convert ISAM Tables to MyISAM Tables?  (Read 1337 times)

Offline chinmay.sahooTopic starter

  • Trade Count: (0)
  • Full Member
  • ***
  • Thank You 2
  • Posts: 159
  • Karma: 0
    • Hot Shaper
How Do I Convert ISAM Tables to MyISAM Tables?
« on: 01-05-2016, 04:18:05 »
If you’ve been using MySQL since before version 3.23, chances are that any preexisting tables are of the ISAM storage engine type. If this is the case, you should convert all such tables to the MyISAM type. Surprisingly, doing so is quite trivial, accomplished with a single ALTER command for each table:

Quote
ALTER TABLE table_name TYPE=MYISAM;

Alternatively, you can use the mysql_convert_table_format utility, which is bundled with the MySQL server. This client works much like mysql or mysqladmin, requiring authorization before any commands are executed. As an example, suppose you want to convert all ISAM tables located in a legacy database named clients to MyISAM:

Quote
%>mysql_convert_table_format -u root -p --type='MYISAM' clients

You can also specifically enumerate the tables that you’d like to convert. For example, suppose that there only two tables that require conversion (namely, companies and staff) in the clients database:

Quote
%>mysql_convert_table_format -u root -p --type='MYISAM' clients companies staff



Note : that this script is capable of converting between BDB, ISAM, and MyISAM tables.


 

Related Topics

  Subject / Started by Replies Last post
3 Replies
1837 Views
Last post 05-19-2010, 16:54:19
by welshboy
0 Replies
1022 Views
Last post 10-08-2011, 03:51:20
by Walalayo
2 Replies
1087 Views
Last post 04-16-2013, 16:43:40
by gomez
0 Replies
502 Views
Last post 02-01-2016, 01:14:25
by chinmay.sahoo
0 Replies
678 Views
Last post 10-15-2016, 05:16:31
by beingchinmay