?
Solved

Mysqldump error

Posted on 2009-07-06
11
Medium Priority
?
812 Views
Last Modified: 2012-08-14
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)
0
Comment
Question by:tomar_10
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
11 Comments
 
LVL 33

Expert Comment

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

Author Comment

by:tomar_10
ID: 24794546
i have tried but did not get sucess
0
 
LVL 26

Accepted Solution

by:
Umesh earned 2000 total points
ID: 24831081
This seems to be because of the some Anti-virus system which regularly scans windows/temp directory ...
Please change the tmpdir path to some other path in your my.ini and restart MySQL and try the dump one more time

tmpdir=F:/mysqlbackup/temp

You can see similar case here..

http://bugs.mysql.com/bug.php?id=25872
0
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

Author Comment

by:tomar_10
ID: 24860026
there is no tmpdir path in my.ini


0
 
LVL 26

Expert Comment

by:Umesh
ID: 24860436
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
0
 

Author Comment

by:tomar_10
ID: 24860802
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.
0
 
LVL 26

Expert Comment

by:Umesh
ID: 24867367
on np!

Regards,
Umesh
0
 

Author Comment

by:tomar_10
ID: 24941657
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

0
 
LVL 26

Expert Comment

by:Umesh
ID: 24941678
Check if there is any way you can exclude the new path from scanning..
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question