11-24-2012
thing is i dont want to enable logging now. i wanted to check the logs for the things which are run on db for past two days... is it possible to find that? or does server has inbuilt logging for all the operations performed on it...?
i checked the link you sent and chattr command is for setting file permission right.
also i have checked in /var/log/mysqld.log but it shows only error traced during mysql start and stop. it wont show mysql operations performed :-(
somehow few entries in DB of my server are missing. i wanted to find out how it happened or who did that. so trying to find to out is there any logs where i could trace out this thing. note that this servers are rebooted a couple of times. :-(
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to write a script which would go search and get the info from the logs based on yesterday timestamp and write yesterday logs in new file. The log file format is as follows:
""""""""""""""""""""""""""... (3 Replies)
Discussion started by: harish.parker
3 Replies
2. Web Development
Anyone have a clue about this?
I have checked the MySQL documentation and it does not seem possible to exclude a row of a table from replication between Master and Slave. It seems that replication in MySQL can only be managed at the table level, not at the row level.
Does anyone know a work... (5 Replies)
Discussion started by: Neo
5 Replies
3. AIX
i in smit , press F6 ,
smit fs , Change / Show Characteristics of an Enhanced Journaled File System
then F6 to see the comand , how can i see the command performed ??
x() { │
│ LIST= ... (5 Replies)
Discussion started by: prpkrk
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
when 2 users are logged as root , how can i find witch one had perform witch command?
Thanks, (1 Reply)
Discussion started by: prpkrk
1 Replies
5. Shell Programming and Scripting
I want to grep the content performed by an User from a file. Suppose that i have a following file
HYD-HMS-2$ ls -lrt
-rw-r--r-- 1 sdfrun sdf 31726356 Aug 1 13:04 journal.03.01082012.19.csv
I could able to grep the content performed by a user by "sed" command as follows
HYD-HMS-2$... (0 Replies)
Discussion started by: duppalav
0 Replies
6. UNIX for Dummies Questions & Answers
I need to write a shell script that allows some system-administration tasks to be preformed automatically from a menu-driven interface. Automate the following tasks:
• Copy directory tree
• Delete files or directories
• Output Information
But I don't understand the question. What is a "menu... (2 Replies)
Discussion started by: femchi
2 Replies
7. UNIX Desktop Questions & Answers
I have an application desigend in PHP and MySQl running on apache web server that I is running on a Amazon EC2 server Centos. I want to implement the master-master and master slave replication and high availability disaster recovery on this application database.
For this I have created two... (0 Replies)
Discussion started by: Palak Sharma
0 Replies
8. Shell Programming and Scripting
Appreciate help for the below issue.
Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt..............
1)if logs exist it should move the logs with extention... (1 Reply)
Discussion started by: Sanjeev G
1 Replies
LEARN ABOUT REDHAT
safe_mysqld
SAFE_MYSQLD (1) mysql.com SAFE_MYSQLD (1)
NAME
safe_mysqld - start the mysqld daemon on Unix.
SYNOPSIS
safe_mysqld [--basedir=path] [--core-file-size=#] [--defaults-extra-file=path] [--defaults-file=path] [--open-files=#] [--datadir=path]
[--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#] [--socket=path] [--timezone=#]
[--user=#]
DESCRIPTION
safe_mysqld adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file.
--basedir=path
--core-file-size=#
--defaults-extra-file=path
--defaults-file=path
--open-files=#
Size of the core file mysqld should be able to create. Passed to ulimit -c.
--datadir=path
--err-log=path
--ledir=path
Path to mysqld
--log=path
--no-defaults
--open-files=#
Number of files mysqld should be able to open. Passed to ulimit -n.
--pid-file=path
--port=#
--socket=path
--timezone=#
Set the timezone (the TZ) variable to the value of this parameter.
--user=#
NOTE
Note that all options on the command line to safe_mysqld are passed to mysqld. If you wants to use any options in safe_mysqld that mysqld
doesn't support, you must specify these in the option file.
SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
(1), replace (1), safe_mysqld (1), which1 (1), zap (1),
AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). 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.mer-
curmedia.com)
safe_mysqld (mysql) 19 December 2000 SAFE_MYSQLD (1)