Solved

Mysqldump error

Posted on 2009-07-06
11
810 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 500 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
Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 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