Error during Backup (mysqldump) - Backup is not full?

[turbe]

Now running 3.7.5 (happened sometimes with 3.7.2 PL1 as well)

Using:

mysqldump --opt -Q -u bahbah -p forum > d:/Backups/Forum/SQL/ForumDBBackup.sql


Sometimes I get this message and the backup file size is small:

mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'tachythreadpost'': Can't create
/write to file 'C:\WINDOWS\TEMP\#sql_b4_0.MYI' (Errcode: 13) (1)


This doesn't happen all the time even though today I tried 4 times and I got the message each time.

I close the board during this backup/dump, even tried stopping Apache this time.

Help appreciated...

Thanks in advance..

[turbe]

Tried again..



C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump --opt -Q -u bahbah -p forum > d:/Backups/Forum/SQL/ForumDBBackup22.sql
Enter password: ******
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'blog\_tachyentry'': Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b4_0.MYI' (Errcode: 13) (1)


C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump --opt -Q -u bahbah -p forum > d:/Backups/Forum/SQL/ForumDBBackup22.sql
Enter password: ******
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'blog\_custom\_block\_parsed'':Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b4_0.MYI' (Errcode: 13) (1)



C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump --opt -Q -u bahbah -p forum > d:/Backups/Forum/SQL/ForumDBBackup22.sql
Enter password: ******
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'blog\_trackback'': Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b4_0.MYI' (Errcode: 13) (1)



C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump --opt -Q -u bahbah -p forum > d:/Backups/Forum/SQL/ForumDBBackup4.sql
Enter password: ******
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'cron'': Can't create/write to file 'C:\WINDOWS\TEMP\#sql_b4_0.MYI' (Errcode: 13) (1)

[Lats]

That's a permissions problem - check your user permissions for that temp directory.

[turbe]

I'll check..

this is on XP, but I'm curious why it's intermittent...

[turbe]

The 2 temp files are clearly being created in /Windows/temp but apparently there is an error during some writes (each time at a different spot during the backup)..

I am logged in as a Administrator as well..

[Lats]

Are you running McAfee?

http://lists.mysql.com/mysql/209856

[turbe]

Thank YOU!!!!, that was it... I made some changes in McAfee and I am not getting those message and errors..

I know, I should have known or searched better..

On McAfee Security Center, I set the "Specify Types of files to scan" on real time scanning, to program files and documents only. This seemed to work. I would have preferred to nail it down just to MySQL or various extensions, but I couldn't figure out how to do this on McAfee Security Center.