09-15-2008
great! Thanks all.
But...
080915 10:02:20 [ERROR] /usr/sbin/mysqld: Table './db/tbl_tb' is marked as crashed and should be repaired
080915 10:02:45 [ERROR] /usr/sbin/mysqld: Table './db/tbl_tb' is marked as crashed and should be repaired
Since the error is repeated on the next line, I want only alert.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a .txt file
Sample:
=====================
NEXT HOST
=====================
AEADBAS001
ip access-list extended BLA_Incoming_Filter
ip access-list extended BLA_Outgoing_Filter
access-list 1 permit xxxxxxxxxxxxxx
access-list 2 permit xxxxxxxxxxxxxx
=====================... (4 Replies)
Discussion started by: I-1
4 Replies
2. UNIX for Advanced & Expert Users
I am trying to cat a file and then grep that file for a number. I can do it fine on other files but this particular file will not do anything. I tried running it on an older file from the same device but it is just not working. The file is nothing more than a flat file on a unix box. Here is just a... (3 Replies)
Discussion started by: jphess
3 Replies
3. Shell Programming and Scripting
Hi All,
I'd like to do this
cat /etc/passwd
and grep -v on the /etc/shells list
I'd like to find all shell that doesn't exist on the /etc/passwd.
Is there an easy way without doing a egrep -v "/bin/sh|/bin/bash................"?
How do I use a file /etc/shells as my list for... (4 Replies)
Discussion started by: itik
4 Replies
4. Shell Programming and Scripting
I am not sure if using cat -n is the most efficient way to split a file into multiple files, one file per line in the source file.
I thought using cat -n would make it easy to process the file because it produces an output that numbers each line that I could then grep for with the regex "^ *$i".... (3 Replies)
Discussion started by: kapu
3 Replies
5. Shell Programming and Scripting
Is there a way using grep or cat a file to create a new file based on whether the first 9 positions of each record is less than 399999999?
This is a fixed file format. (3 Replies)
Discussion started by: ski
3 Replies
6. Shell Programming and Scripting
Hi,
I still have the problem with directing information from cat or grep to a variable.
For instance:
XMSG "$(date +%Y_%m_%d)_error_report.txt" "$(cat "$(date +%Y_%m_%d)_error_report.txt")" &Works! The text received by cat is directed to my function.
If it is written like this, my... (2 Replies)
Discussion started by: haukee
2 Replies
7. UNIX for Dummies Questions & Answers
Hello,
i need to search one word (snp1) from many files and copy the content of the columns of this word in new file.
example:
file 1:
SNP BP CHR P
snp1 1 3 0.01
snp2 2 2 0.05
.
.
file 2:
SNP BP CHR P
snp1 1 3 0.06
snp2 2 2 0.3
output... (6 Replies)
Discussion started by: biopsy
6 Replies
8. Shell Programming and Scripting
Hello
someone told me to use
OS=`awk '{print int($3)}' < /etc/redhat-release`
instead of
OS=cat /etc/redhat-release | `awk '{print int($3)}'`
any idea for the reason ? (5 Replies)
Discussion started by: nimafire
5 Replies
9. UNIX for Dummies Questions & Answers
Hi Guys
This is my first post so I am not sure how things go here. I'm sorry if I'm breaking the rule or something. Feel free to correct me about that :)
So as I was saying...
I'd been trying to grep this folder containing 900,000 txt files but seems no luck. I get either "No such file... (6 Replies)
Discussion started by: Nexeu
6 Replies
10. Shell Programming and Scripting
Hello,
I'm on a remote computer by SSH. How can I get the output of "cat file" into a file on the local computer?
I cannot use scp, because it's blocked.
something like:
ssh root@remote_maschine "cat /file" > /locale_machine/file
:rolleyes: (2 Replies)
Discussion started by: borsti007
2 Replies
LEARN ABOUT CENTOS
mysql_install_db
MYSQL_INSTALL_DB() MYSQL_INSTALL_DB()
NAME
mysql_install_db - initialize MySQL data directory
SYNOPSIS
mysql_install_db [options]
DESCRIPTION
mysql_install_db initializes the MySQL data directory and creates the system tables that it contains, if they do not exist.
To invoke mysql_install_db, use the following syntax:
shell> mysql_install_db [options]
Because the MySQL server, mysqld, needs to access the data directory when it runs later, you should either run mysql_install_db from the
same account that will be used for running mysqld or run it as root and use the --user option to indicate the user name that mysqld will
run as. It might be necessary to specify other options such as --basedir or --datadir if mysql_install_db does not use the correct
locations for the installation directory or data directory. For example:
shell> bin/mysql_install_db --user=mysql
--basedir=/opt/mysql/mysql
--datadir=/opt/mysql/mysql/data
mysql_install_db needs to invoke mysqld with the --bootstrap and --skip-grant-tables options (see Section 2.3.2, "Typical configure
Options"). If MySQL was configured with the --disable-grant-options option, --bootstrap and --skip-grant-tables will be disabled. To handle
this, set the MYSQLD_BOOTSTRAP environment variable to the full path name of a server that has all options enabled. mysql_install_db will
use that server.
mysql_install_db supports the following options, which can be specified on the command line or in the [mysql_install_db] and (if they are
common to mysqld) [mysqld] option file groups.
o --basedir=path
The path to the MySQL installation directory.
o --force
Cause mysql_install_db to run even if DNS does not work. In that case, grant table entries that normally use host names will use IP
addresses.
o --datadir=path, --ldata=path
The path to the MySQL data directory.
o --rpm
For internal use. This option is used by RPM files during the MySQL installation process.
o --skip-name-resolve
Use IP addresses rather than host names when creating grant table entries. This option can be useful if your DNS does not work.
o --srcdir=path
For internal use. The directory under which mysql_install_db looks for support files such as the error message file and the file for
populating the help tables. This option was added in MySQL 5.1.14.
o --user=user_name
The login user name to use for running mysqld. Files and directories created by mysqld will be owned by this user. You must be root to
use this option. By default, mysqld runs using your current login name and files and directories that it creates will be owned by you.
o --verbose
Verbose mode. Print more information about what the program does.
o --windows
For internal use. This option is used for creating Windows distributions.
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_INSTALL_DB()