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