Gurus,
I'm running a Windows Server 2003 cmd shell script to backup my databases using:
%mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% >
%bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql
@ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql
It's been running fine until I've had to change
n my server's log and it appears that a
> connection is given an ID (which is where you see which user it was) then
> that ID is used throughout the log to indicate which queries have been
> executed from that connection.
>
> Hope you get this sorted out!
>
> Andy
>
>
Hi folks,
We're experiencing a really bizarre thing.
One of our mysql 5.0 databases is mysteriously and constantly being dropped.
This is a cap from our binlog:
#090409 15:09:13 server id 1 end_log_pos 326997
Query thread_id=9923 exec_time=1 error_code=0
SET TIMESTAMP=1239304153/*