Visit The New, Modern Unix Linux Community

Linux and UNIX Man Pages

Test Your Knowledge in Computers #510
Difficulty: Easy
Variable names cannot be the same as any reserved word as the language would not be able to distinguish between them.
True or False?
Linux & Unix Commands - Search Man Pages

mysql_fix_extensions(1) [centos 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)

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)

8 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

Featured Tech Videos