Got follwing error in mysql database backup

I am trying to backup database with query in D drive as – BACKUP DATABASE market TO DISK = ‘D:\Pics\market.bak’; but getting error, What am I doing wrong?

7 errors were found during analysis.  An expression was expected. (near "DATABASE" at position 7) Unrecognized keyword. (near "DATABASE" at position 7) Unexpected token. (near "market" at position 16) Unrecognized keyword. (near "TO" at position 24) Unrecognized keyword. (near "DISK" at position 27) Unexpected token. (near "=" at position 32) Unexpected token. (near "'D:\Pics\market.bak'" at position 34) SQL query: Copy  BACKUP DATABASE market TO DISK = 'D:\Pics\market.bak' 

MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DATABASE market TO DISK = ‘D:\Pics\market.bak” at line

enter image description here

Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.