MySQL 3.23, 4.0, 4.1 Reference Manual :: 8 Client and Utility Programs :: 8.21 mysql_fix_extensions — Make Table Filename Extensions Lowercase
Section Navigation [Toggle]
- 8 Client and Utility Programs
- 8.1 Overview of Client and Utility Programs
- 8.2 my_print_defaults — Display Options from Option Files
- 8.3 myisam_ftdump — Display Full-Text Index information
- 8.4 myisamchk — MyISAM Table-Maintenance Utility
- 8.5 myisamlog — Display MyISAM Log File Contents
- 8.6 myisampack — Generate Compressed, Read-Only MyISAM Tables
- 8.7 mysql — The MySQL Command-Line Tool
- 8.8 mysqlaccess — Client for Checking Access Privileges
- 8.9 mysqladmin — Client for Administering a MySQL Server
- 8.10 mysqlbinlog — Utility for Processing Binary Log Files
- 8.11 mysqlcheck — A Table Maintenance and Repair Program
- 8.12 mysqldump — A Database Backup Program
- 8.13 mysqlhotcopy — A Database Backup Program
- 8.14 mysqlimport — A Data Import Program
- 8.15 mysqlmanagerc — Internal Test-Suite Program
- 8.16 mysqlmanager-pwgen — Internal Test-Suite Program
- 8.17 mysqlshow — Display Database, Table, and Column Information
- 8.18 mysql_convert_table_format — Convert Tables to Use a Given Storage Engine
- 8.19 mysql_explain_log — Use EXPLAIN on Statements in Query Log
- 8.20 mysql_find_rows — Extract Queries from Update Log
- 8.21 mysql_fix_extensions — Make Table Filename Extensions Lowercase
- 8.22 mysql_setpermission — Interactively Set Permissions in Grant Tables
- 8.23 mysql_tableinfo — Generate Database Metadata
- 8.24 mysql_waitpid — Kill Process and Wait for Its Termination
- 8.25 mysql_zap — Kill Processes That Match a Pattern
- 8.26 perror — Explain Error Codes
- 8.27 replace — A String-Replacement Utility
- 8.28 resolveip — Resolve Hostname to IP Address or Vice Versa
- 8.29 resolve_stack_dump — Resolve Numeric Stack Trace Dump to Symbols
mysql_fix_extensions converts the
extensions for MyISAM (or
ISAM) table files to lowercase. It looks
for files with an extension that that matches any lettercase
variant of .frm,
.myd, .myi,
.isd, and .ism and
renames them to have extensionsn 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
User Comments
Add your own comment.