- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 5.0 Reference Manual :: 4 MySQL Programs :: 4.6 MySQL Administrative and Utility Programs :: 4.6.13 mysql_fix_extensions — Normalize Table Filename 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 mysqlhotcopy — A Database Backup Program
- 4.6.9 mysqlmanager — The MySQL Instance Manager
- 4.6.10 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 4.6.11 mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 4.6.12 mysql_find_rows — Extract SQL Statements from Files
- 4.6.13 mysql_fix_extensions — Normalize Table Filename Extensions
- 4.6.14 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 4.6.15 mysql_tableinfo — Generate Database Metadata
- 4.6.16 mysql_waitpid — Kill Process and Wait for Its Termination
- 4.6.17 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
filenames (such as Windows) to a system with case-sensitive
filenames.
Invoke mysql_fix_extensions like this, where
data_dir is the pathname to the MySQL
data directory.
shell> mysql_fix_extensions data_dir
© 1995-2008 MySQL AB, 2008 Sun Microsystems, Inc.
User Comments
Add your own comment.