mysql的数据备份报错

Question

mysql 5.7，数据备份，代码是网上扒的，但却报语法错误

原代码mysqldump -u root -p mydb815 student > d:\backup\student_back.sql

######结果: you have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqldump -u root -p mydb815 student > :c\backup\student_back.sql' at line 1

Answer 1

进入你原来mysql版本的bin目录下终端执行指令：注意我这里c盘没权限 但d盘成功了哈