当前位置: 动力学知识库 > 问答 > 编程问答 >

mysql - How to redirect a backup file into another folder/drive while using mysqldump?

问题描述:

I need to use mysqldump to take backups for databases. but while executing the command, it throws the error " Access Denied ".

I found that the problem is not with the MySQL. But, it is with Windows file system. I don't have enough write privileges in bin folder placed in C drive.

How to get rid of this issue ?? How can i change the backup file path ??

thanks in advance.

网友答案:

use following

mysqldump --host=HOST-DETAILS -u USERNAME -p DBNAME > D:\sqldump\dump1.sql
分享给朋友:
您可能感兴趣的文章:
随机阅读: