MySQL 5.5 Reference Manual :: 4 MySQL Programs :: 4.6 MySQL Administrative and Utility Programs :: 4.6.12 mysql_fix_extensions — Normalize Table File Name Extensions
Section Navigation [Toggle]
- 4.6 MySQL Administrative and Utility Programs
- 4.6.1 innochecksum — Offline InnoDB File Checksum Utility
- 4.6.2 myisam_ftdump — Display Full-Text Index information
- 4.6.3 myisamchk — MyISAM Table-Maintenance Utility
- 4.6.4 myisamlog — Display MyISAM Log File Contents
- 4.6.5 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 4.6.6 mysqlaccess — Client for Checking Access Privileges
- 4.6.7 mysqlbinlog — Utility for Processing Binary Log Files
- 4.6.8 mysqldumpslow — Summarize Slow Query Log Files
- 4.6.9 mysqlhotcopy — A Database Backup Program
- 4.6.10 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.11 mysql_find_rows — Extract SQL Statements from Files
- 4.6.12 mysql_fix_extensions — Normalize Table File Name Extensions
- 4.6.13 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.14 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.15 mysql_zap — Kill Processes That Match a Pattern
mysql_fix_extensions converts the extensions
for MyISAM (or ISAM) table
files to their canonical forms. It looks for files with
extensions matching any lettercase variant of
.frm, .myd,
.myi, .isd, and
.ism and renames them to have extensions of
.frm, .MYD,
.MYI, .ISD, and
.ISM, respectively. This can be useful
after transferring the files from a system with case-insensitive
file names (such as Windows) to a system with case-sensitive
file names.
Invoke mysql_fix_extensions like this, where
data_dir is the path name to the
MySQL data directory.
shell> mysql_fix_extensions data_dir
User Comments
Add your own comment.