用mysqldump備份db時出現錯誤
當利用 mysqldump.exe 去備份database時,出現以下錯誤:
mysqldump.exe: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
解決方法只要加上一個參數在最後便可 "--no-tablespaces"
mysqldump -h 123.123.xxx.17 --password --user myuser mydb > ./temp/database_bkup.sql --no-tablespaces