[MDEV-18191] unable to backup mariadb 10.0.36 database Created: 2019-01-09  Updated: 2019-01-24  Resolved: 2019-01-24

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.0.36
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: vinod bathi Assignee: Unassigned
Resolution: Not a Bug Votes: 0
Labels: None

Attachments: PNG File 2019-01-09_22-30-14.png    

 Description   

I am using windows server 2016, in this, I have installed mariadb 10.0.36, after hosting a site, I am trying to take a backup whenever I try to take a backup it displays an error message like this

"SQL Error (1604): 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 'mysqlhostcopy db_name' [C:\Users\Administrator\Desktop]' at line 1"

Please provide solution

 Comments   
Comment by Elena Stepanova [ 2019-01-24 ]

From the output that you pasted, it appears that you're using some UI to the database server, and trying to run mysqlhotcopy as an SQL query.
If that's so, this is not how it's used, please refer to documentation for instructions. Please also note that the tool is deprecated.

Generated at Thu Feb 08 08:42:11 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.