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

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

Re: db is bring dropped, binlog help

2009-04-09 Thread John Sun
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 John Sun wrote: Hi folks, We're experiencing a really bizarre thing. One of our mysql 5.0 databases is mysteriously