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 :
Code:
$ 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 mysql mysql 8638 Dec 22 12:22 b.frm
-rw-rw---- 1 mysql mysql 114688 Feb 5 16:01 b.ibd
-rw-rw---- 1 mysql mysql 8638 Dec 22 12:22 c.frm
-rw-rw---- 1 mysql mysql 8638 Dec 22 12:22 d.frm
From the above list c.ibd & d.ibd file only missing. so i am expecting the list of files that not the having .ibd files.
Output :
Code:
-rw-rw---- 1 mysql mysql 8638 Dec 22 12:22 c.frm
-rw-rw---- 1 mysql mysql 8638 Dec 22 12:22 d.frm
Hi
on friday one user from peoplesoft lost his file.
mean he don't know he saved it or removed it.
but, he need the file and it is most valuable.
so i searched the file in the server, i got the some with same name on /peoplesoft/..../print directory.
is these two are the same one or... (1 Reply)
Hi, all:
I've got two folders, say, "folder1" and "folder2".
Under each, there are thousands of files.
It's quite obvious that there are some files missing in each. I just would like to find them. I believe this can be done by "diff" command.
However, if I change the above question a... (1 Reply)
counter=0;
while read line;
do ] && let counter=counter+1; done < input_file.txt
echo $counter
The above code is reading a file line by line and checking whether the filenames mentioned in the file exist or not .
At present the o/p is value of counter
I want to echo out the name of... (5 Replies)
Hi Friends,
Please help me to sort out this problem, I am running this in centos o/s and whenever I run this script I am getting "find: missing argument to `-exec' " but when I run the same code in the command line I didn't find any problem. I am using perl script to run this ... (2 Replies)
How can I recursively find all files in a directory and print out the file and first line number of any text blocks that match the below cases?
This would seem to involve find, xargs, *grep, regex, etc.
In summary, I want to find so-called empty "try-catch blocks" that do not contain code... (0 Replies)
Hi All,
Below is my requirement.
I want to display the missing files in the directory. Below is my example
From SFTP we are copying 10 files every day. if any files missed on that day need to send a notification with missing files
Test1.dat
20121107_00_file.csv
20121107_01_file.csv... (8 Replies)
Dear all
i am having file with max 24 entries. i want to find which sequence is missing
file is like this
df00231587.dat
df01231587.dat
df03231587.dat
df05231587.dat
.
.
.
df23231587.dat
the changing seq is 00-23,so i would like to find out which seq is missing like in above... (13 Replies)
Hello experts!
I have 2 files.
file1 is a list file containing uniquely names. e.g.:
name1 number number
name2 number number
name5 number number
name10 number number
...
file2 is a data file arbitrary containing the names of file1 in paragraphs separated by "10" e.g.
name4 ... (3 Replies)
Hi,
I'm writing a post-upgrade script and I want to find which files don't have read and execute to everyone.
I can run a find . ! -perm, but then I have to use a list of the possible permissions (777,775, 755 etc). Is there a more elegant solution?
Thanks (2 Replies)
Hi All,
In the file names we have dates.
Based on the file format given by the user,
if any file is not existed for a particular date with in a given interval we should consider that file is missing.
I have the below files in the directory /bin/daily/voda_files.
... (9 Replies)
Discussion started by: nalu
9 Replies
LEARN ABOUT OPENSOLARIS
perror
perror(1) MySQL database perror(1)NAME
perror - describes a system or MySQL error code.
SYNOPSIS
perror [OPTIONS] [ERRORCODE [ERRORCODE...]]
DESCRIPTION
Can be used to display a description for a system error code, or an MyISAM/ISAM table handler error code. The error messages are mostly
system dependent.
OPTIONS
-?|--help
Displays this help and exits.
-I|--info
Synonym for the above.
-s|--silent
Only print the error message
-v|--verbose
Print error code and message (default).
-V|--version
Displays version information and exits.
EXAMPLE
shell> perror 64 79 Error code 64: Machine is not on the network Error code 79: Can not access a needed shared library
SEE ALSO isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysqlshow(1), mysql_zap(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 perror(1)