出现1064 - 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“”可能的原因
备份
- 输入代码时需在bin目录下进行
username: 用户名F:\apps\MySQL\MySQL Server\bin>mysqldump -u username -p databaseName > D:\dataBack\backup.sql
database: 需要备份的数据库名
恢复
- 需在mysql>目录下输入
use dataname; scource D:\dataBack\backup.sql;