Sunday, March 28, 2010

mysqldump: Couldn't execute SHOW TRIGGERS LIKE

I cann't create mysqldump, and error in result
"mysqldump: Couldn't execute SHOW TRIGGERS LIKE"

Q: How to resolve mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

A: Please access Mcafee VirusScan Console then Disable Access Protection and On-Scanner Access. Right click on properties On-Scanner Access >> All Processess >> Detection >> Exclusions >> write the folder, and check list 'Also exclude subfolders', so you can solving error mysqldump: Couldn't execute SHOW TRIGGERS LIKE error can't create/write to file 'C:\WINNT\TEMP'

Thursday, March 11, 2010

Excel to MySQL

Panduan:
http://www.automateexcel.com/2005/11/01/connect_excel_to_mysql_database/
http://apacheguide.org/myodbc.php

Tools:
download myODBC
http://dev.mysql.com/downloads/mirror.php?id=376347#mirrors