http://www.dedecms.com/knowledge/data-base/mysql/2012/0819/8366.html
普通用户备份mysql 报错
无lock tables权限 报Access denied for user 'dbuser'@'localhost' to database 'db' when using LOCK TABLES
主要原因是该用户无lock tables 该权限,处理办法:
1. 给该普通用户赋予lock tables 权限,建议是删除该用户,重新用mysql命令建
2. 加上--skip-lock-tables即可
mysqldump -udbuser -p dbname --skip-lock-tables > dbname.sql
3. 使用root 备份
http://www.hongkevip.com/fuwuqi/linuxfuwuqi/29990.html
解决mysqldump: Couldn t execute show fields from table错误
2014-12-10 09:38 出处:网络转载 人气:188 评论()
红客VIP(http://www.hongkevip.com):解决mysqldump: Couldn t execute show fields from table错误
下文来给各位介绍
mysqldump: Couldn't execute 'show fields from `table`': Can't create/write to file 'W:/sysTemp/#sql7c4_48_5.MYI' (Errcode: 2) (1)
最后查阅资料,说是权限的问题,但是发现只要在my.ini里设置个tmpdir的路径就可以了
给mysql设置一个临时文件夹
tmpdir=D:/mysqltmp
然后记得重启下数据库的服务
net stop mysql
net start mysql
然后用mysqldump命令导出数据库就可以正常导出了。
http://buxianglei521bxl.blog.163.com/blog/static/1082464732013112572533288/
出错提示是
mysqldump: mysqldump: Couldn't execute 'show fields from `pw_actions`': Can't create/write to file'C:\WINNT\TEMP\#sql_23c_0.MYI' (Errcode: 17) (1)
解决办法:
在my.ini最后一行加入:
set-variable=max_allowed_packet=134217728