mysqldump 备份命令错误 Can't create/write to file '' (Errcode: 13)
来源:互联网 发布:qt图形界面编程入门 编辑:程序博客网 时间:2024/05/16 14:28
先说一下我的备份过程
1. 把数据库database1 备份到backup.sql 命令中
mysqldump -u root -p --database database1 -r backup.sql
2. 把backup.sql 导入到数据库中
mysql -h localhost -u root -p < backup.sql
但是在步骤1时出现下面的错误:
mysqldump: Can't create/write to file 'backup.sql' (Errcode: 13)
原来我不是管理员身份,对目录没有写权限。所以如果是windows7用户,以管理员身份运行cmd,然后在cmd里面运行上面命令就可以了。
- mysqldump 备份命令错误 Can't create/write to file '' (Errcode: 13)
- mysqldump: Got error: 1: Can't create/write to file '/data/export/test.txt' (Errcode: 13)
- mysqldump: Got error: 1: Can't create/write to file (Errcode: 13
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- ERROR 1 (HY000): Can't create/write to file'/' (Errcode: 13)错误解决
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- MySQL下“Can’t create/write to file xxx (Errcode: 13)”错误的解决方法
- mysqldump: Got error: 1: Can't create/write to file '/usr/local/mysql/data/bak/t4.txt' (Errcode: 13
- 解决Mysql错误:Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1344_0.MYD' (Errcode: 17)
- 解决Mysql错误:Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1344_0.MYD' (Errcode: 17)
- 解决Mysql错误:Can't create/write to file 'C:\WINDOWS\TEMP\#sql_1344_0.MYD' (Errcode: 17)
- ERROR 1 (HY000): Can't create/write to file '/test.txt' (Errcode: 13)
- /usr/libexec/mysqld: Can’t create/write to file ‘/tmp/’ (Errcode: 13)
- Can't create/write to file '/tmp/#sql_909_0.MYI' (Errcode: 13)
- [hive]Can't create/write to file '/tmp/#sql_2290_0.MYI' (Errcode: 13)
- 解决:CentOS下MySQL执行select ... into outfile ...: Can't create/write to file '...' (Errcode: 13)
- Use Memory Layout from Target Dialog
- linux下NAT内网连通IPv6的实现
- 昨天,今天,明天830
- 震区归来话旅游867
- 第一次C程序设计上机报告
- mysqldump 备份命令错误 Can't create/write to file '' (Errcode: 13)
- onActivityResult
- 贴一下今天python中文乱码问题解决办法。
- Chrome源码剖析【三】
- 女生节最欢乐的事——
- 声卡常见故障分析
- 查找所有SEQUENCE、TABLE
- Chrome源码剖析 【四】
- 进程与线程的区别(转)