Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_fix_extensions(1) [linux man page]

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 (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved. 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
Oracle Corporation (http://dev.mysql.com/). MySQL 5.5 01/30/2014 MYSQL_FIX_EXTENSI(1)

Check Out this Related Man Page

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)
Man Page

13 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Oracle documentation online

Anyone know where I can find good information/documentation online? Thanks, Chuck (1 Reply)
Discussion started by: 98_1LE
1 Replies

2. UNIX for Dummies Questions & Answers

Move files

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)
Discussion started by: yshahiac
3 Replies

3. UNIX for Dummies Questions & Answers

changing extensions for multiple files at once

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)
Discussion started by: Straitsfan
1 Replies

4. Solaris

Intimate Shared Memory (ISM)

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)
Discussion started by: sprout009
20 Replies

5. Shell Programming and Scripting

Problem with tr command

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)
Discussion started by: raghavendra.cse
14 Replies

6. UNIX for Dummies Questions & Answers

get total size of files

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)
Discussion started by: kaushik02018
6 Replies

7. Shell Programming and Scripting

Ignoring certain extensions

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)
Discussion started by: anushree.a
3 Replies

8. UNIX for Dummies Questions & Answers

Moving files from Windows 7 to Unix

Hi I'm sure this question has been asked before. I need to know how to write a script that will transfer a file from a windows directory to a UNIX directroy that can be ran from an Oracle Concurrent Program... I really don't know unix at all. PLEASE HELP! :wall: (3 Replies)
Discussion started by: kenlook123
3 Replies

9. Solaris

Panic error

Hi All, I am getting the below error after login to box. SunOS Release 5.10 Version Generic_147440-02 64-bit Copyright (c) 1983, 2011, Oracle and/or its affiliates. All rights reserved. os-io Cross trap sync timeout: at cpu_sync.xword: 0x1010panic: failed to sto p cpu8 panic: failed to... (1 Reply)
Discussion started by: chetansingh23
1 Replies

10. Shell Programming and Scripting

Perl script - Help me extracting a string

I have input like this : TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 07-FEB-2012 04:19:45 Copyright (c) 1997, 2009, Oracle. All rights reserved. Used parameter files: /t3local_apps/apps/oracle/product/11.2.0/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve... (3 Replies)
Discussion started by: dnam9917
3 Replies

11. UNIX and Linux Applications

MySQL - optimize using other storage volume

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)
Discussion started by: treesloth
1 Replies

12. Shell Programming and Scripting

Difficulty with incrementing Variables and using the results in a If/else statement

Environment: BASH version: GNU bash, version 3.2.51(1)-release (sparc-sun-solaris2.10) Copyright (C) 2007 Free Software Foundation, Inc. OS: Oracle Solaris 10 9/10 s10s_u9wos_14a SPARC Copyright (c) 2010, Oracle and/or its affiliates. All rights reserved. ... (4 Replies)
Discussion started by: os2mac
4 Replies

13. Shell Programming and Scripting

Find missing .ibd files

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)
Discussion started by: k_manimuthu
3 Replies