Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
Lewis - DBA wrote:
Is this possible with MYSQL using the innodb engine? If so, what is
the command/process to make this happen.
Thanks in advance,
~
Clyde Lewis
Database Administrator
~
Clyde Lewis
Database Administrator
This will be not that easy as there is a large array of different
users accessing the DBA at different time during the day/night.
CL
t 11:58 AM 8/3/2007, Edward Kay wrote:
-Original Message-
From: Clyde Lewis - DBA [mailto:[EMAIL PROTECTED]
Sent: 03 August 2007 16:55
To: MySQL
Guys,
I would like to know if there is a way to have individual databases
under the same instance or server write to separate binary log
files. The idea is to have multiple binary log file for each
database on the same server. The problem that I experiencing is
sorting through the binary
the insert or update that is giving foreign key
fail error, know the position just before this sql and recovery till that
position and then recovery from position after this sql still till the end
of file.
regards
anandkl
On 6/20/07, Clyde Lewis - DBA [EMAIL PROTECTED] wrote:
Guys,
I'm
Guys,
I'm attempting to reapply a number of bin-log files in a effort to
restore all changes that was made to a database. I'm performing the
following command, but continue to get a foreign key constraint error
message when doing so. Has anyone ever ran into this issue, and if
so, what is a