MYSQL_FIX_EXTENSI(1) MySQL Database System MYSQL_FIX_EXTENSI(1)NAME
mysql_fix_extensions - normalize table file name extensions
SYNOPSIS
mysql_fix_extensions data_dir
DESCRIPTION
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
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 http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 MYSQL_FIX_EXTENSI(1)
Check Out this Related Man Page
RESOLVEIP(1) MySQL Database System RESOLVEIP(1)NAME
resolveip - resolve host name to IP address or vice versa
SYNOPSIS
resolveip [options] {host_name|ip-addr} ...
DESCRIPTION
The resolveip utility resolves host names to IP addresses and vice versa.
Invoke resolveip like this:
shell> resolveip [options] {host_name|ip-addr} ...
resolveip supports the following options.
o --help, --info, -?, -I
Display a help message and exit.
o --silent, -s
Silent mode. Produce less output.
o --version, -V
Display version information and exit.
COPYRIGHT
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 http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Sun Microsystems, Inc. (http://www.mysql.com/).
MySQL 5.1 04/06/2010 RESOLVEIP(1)
I have multiple file with names
april.0001.frm.edi
april.0002.frm.edi
I created a list with all the file names which has "860" inside the file and named the list as april-860-list
I need to move all the files to name
CHRY.860.01
CHRY.860.02
from that list.
How do I do that?
I... (3 Replies)
I copied some files to another folder, and I want to change them from .doc extensions to .txt extensions. I tried using the cp and mv commands, but it didn't work. Is it possible to change file extensions with these commands, and if so how do I do it? I tried using the * wildcard (say cp *.doc... (1 Reply)
Dear all,
Anyone could help to explain me about ISM? I use SunOS 5.10 and have 3 questions here:
1. Is it true that the ISM value will be set to TRUE by default on either global or container box of Solaris?
2. Is it true if the ISM is TRUE, then the swap to disk (virtual memory) won't work... (20 Replies)
Hi,
I have getting problem with tr command, here is my problem
I Have file CntryCd_100302.wk
When i do like this it works fine
dt=`date +%y%m%d`
data_dir=/usr/apps/mp/script/UMTS/CRE2/data
tr "(){}\"'<>;&@" " " < CntryCd_100302.wk > CntryCd_100302.temp
But... (14 Replies)
as we use du - sh *.frm
In This command It will show the list of files and size
But I want the Total size that these files in directory with extension .frm
How can we do This (6 Replies)
Dear Friends,
I want to move all the files to temp folder except files having following extensions which are case sensitive.
.ttM
.Hmt
.dMt
Request you to guide me to do the same
Thank you in advance
Anushree (3 Replies)
So, I need to optimize a very large MySQL table. This process creates a TMD that seems to approach the size of the original MYD. The problem is that we don't have that much space left on the volume that the MySQL files are on. Is there a way to get the system to use another storage volume on a... (1 Reply)
Hi,
I have mysql file that extension is .frm and .ibd file.
I am trying the to get command line utility to get missing .ibd file.
for example:
Input :
$ ls -al
-rw-rw---- 1 mysql mysql 8684 Dec 22 12:22 a.frm
-rw-rw---- 1 mysql mysql 114688 Feb 5 16:01 a.ibd
-rw-rw---- 1... (3 Replies)