Solved

Mysqldump error

Posted on 2009-07-06
11
800 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
  • 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:
ushastry 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
 

Author Comment

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


0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 26

Expert Comment

by:ushastry
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:ushastry
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:ushastry
ID: 24941678
Check if there is any way you can exclude the new path from scanning..
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Both Easy and Powerful How easy is PHP? http://lmgtfy.com?q=how+easy+is+php (http://lmgtfy.com?q=how+easy+is+php)  Very easy.  It has been described as "a programming language even my grandmother can use." How powerful is PHP?  http://en.wikiped…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now