mysqldump.exe gives "Access Denied" for user

2009-04-22 Thread John Sun
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

Re: db is bring dropped, binlog help

2009-04-09 Thread John Sun
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 > >

db is bring dropped, binlog help

2009-04-09 Thread John Sun
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/*