Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
D
Just convert your binary log file into sql file using mysqlbinlog tools and
search the deleted record between 12 AM to 2 AM and reinsert it.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Kranthi wrote:
From: Kranthi
Subject: RE: Recover Records
To: "'Jangita'"
Cc: mysql@lists.mysql.com
Hi,
The best way to use sync the master and slave is using mk-checksum tools. just
google it and use the the tools for online sync of master and slave.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Norman Khine wrote:
From: Norman Khine
Subject: master-slave replication sync problems.
T
The account has full permission on all the databases.
--- On Fri, 20/8/10, Ananda Kumar wrote:
From: Ananda Kumar
Subject: Re: MySQL Server has gone away
To: "jitendra ranjan"
Cc: "Krishna Chandra Prajapati" , "Prabhat Kumar"
, mysql@lists.mysql.com
Date: Fr
y-bin.01' (relay_log_pos 4)
100817 6:42:11 [ERROR] Could not find target log during relay log initialization
100817 6:42:11 [ERROR] Failed to initialize the master info structure
100817 6:42:11 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/va
Hi,
Whenever i run any commnd on mysql it gives message as below then gives the
result successfully. What is the reason of the below error message :
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 264550
Current database: *** NONE ***
Hi,
We have myisam tables which has round 10 lakhs of records in each tables.I want
to search the records based on index. What should be the value of
max_seeks_for_key as it is set at default 4294967295.
Thanks in advance.
Jeetendra Ranjan
MySQL DBA
As our file descriptor does not allow to increase the table_cache is there any
other way to decrease the occurence of opened_table ?
--- On Fri, 13/8/10, Gavin Towey wrote:
From: Gavin Towey
Subject: RE: opened_table status
To: "jitendra ranjan" , "mysql@lists.mysql.com"
Hi,
I have opened_table status is too high but i don't want increase the value of
table_cache and also dont want to flush table because it will reset the query
cache.
Now my question is how can i decrease the opened_table status ?
Thanks in advance
Jeetendra Ranjan
MySQL DBA
