asked on

Mysqldump error

I am facing error while taking backup of maysql database
F:\mysqlbackup\july09>mysqldump -u root -p --all-databases > bug_all06july09.sql

Enter password: ****
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'priority'': Can't create/write
to file 'C:\WINDOWS\TEMP\#sql_84c_0.MYI' (Errcode: 17) (1)

snoyes_jw

perror 17 says 'File exists' - looks like something didn't get cleaned up before. Empty the C:\Windows\Temp folder and try it again.

tomar_10

ASKER

i have tried but did not get sucess

ASKER CERTIFIED SOLUTION

Umesh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tomar_10

ASKER

there is no tmpdir path in my.ini

Umesh

If its not there then its taking default path... which is windows/tmp... check the output of below SQL command..

show variables like 'tmpdir';

Later you can change this by adding below line to your my.ini

tmpdir=F:/mysqlbackup/temp

tomar_10

ASKER

Output of the command

mysql> show variables like 'tmpdir';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| tmpdir | C:\WINDOWS\TEMP |
+---------------+-----------------+
1 row in set (0.00 sec)

Well i will let you know after changing the path. it require some downtime.

Umesh

on np!

Regards,
Umesh

tomar_10

ASKER

yes it is due to macfee only , i have changed the path.
now it is showing error to the new path.
I am using virusscan enterprise 8.5i

Umesh

Check if there is any way you can exclude the new path from scanning..