mysql_fix_extensions − normalize table file name extensions


mysql_fix_extensions data_dir


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


Copyright 2007-2008 MySQL AB, 2008-2010 Sun Microsystems, Inc.

This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as published by the Free Software Foundation; version 2 of the License.

This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see


For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online at


Sun Microsystems, Inc. (

More Linux Commands

gnutls_x509_crt_get_issuer_alt_name(3) - API function.......
This function retrieves the Issuer Alternative Name (, contained in the given certificate in the X509v3 Certificate Extensions. When the SAN type is o

gslj(1) Format and print text using ghostscript br gsbj Form
This utility provides functionality approximately equivalent to the Unix enscript(1) program. It prints plain text files using a single font. It currently handl

glIndexsv(3gl) - set the current color index (Man Page).....
glIndex updates the current (single-valued) color index. It takes one argument, the new value for the current color index. The current index is stored as a floa

wipefs(8) - wipe a filesystem signature from a device.......
wipefs can erase filesystem, raid or partition-table signatures (magic strings) from the specified device to make the signatures invisible for libblkid. wipefs

screen(1) - screen manager with VT100/ANSI terminal emulatio
Screen is a full-screen window manager that multiplexes a physical terminal between several processes (typically interactive shells). Each virtual terminal prov

Encode::Detect::Detector(3pm) - Detects the encoding of data
This module provides an interface to Mozillas universal charset detector, which detects the charset used to encode data. METHODS $charset = Encode::Detect::Dete

standards(7) - C and UNIX Standards - Linux manual page.....
The CONFORMING TO section that appears in many manual pages identifies various standards to which the documented interface conforms. The following list briefly

psfxtable(1) - handle Unicode character tables for console f
psfxtable handles the embedded Unicode character table for .psf format console fonts. It reads a font and possibly a table and writes a font and/or a table. psf

XSetDeviceMode(3) - change the mode of a device (Man Page)
The XSetDeviceMode request changes the mode of an input device that is capable of reporting either absolute positional information or relative motion informatio

glLightModel(3gl) - set the lighting model parameters.......
glLightModel sets the lighting model parameter. pname names a parameter and params gives the new value. There are three lighting model parameters: GL_LIGHT_MODE

set_max_field(3form) - field buffer control - Linux man page
The function set_field_buffer sets the numbered buffer of the given field to contain a given string: * Buffer 0 is the displayed value of the field. * Other num

vmsplice(2) - splice user pages into a pipe - Linux man page
The vmsplice() system call maps nr_segs ranges of user memory described by iov into a pipe. The file descriptor fd must refer to a pipe. The pointer iov points

We can't live, work or learn in freedom unless the software we use is free.