Discussion Locked

is their any sql query to back up my database in sqlyog?

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

hi guys.

im newly employed, and this is my first time on sqlyog. and i have this kind of problem. i want to use sql query instead of manual input on importing and exporting my database.to do this i used the "BACKUP DATABASE
`sqlquery_testing`
TO
DISK='C:\_DataBase_BackUp\DB_BackUp Jun 27, 2018\SQLQUERY_TESTING.sql'
WITH FORMAT" but thier was an error
" queries executed, 0 success, 1 errors, 0 warnings

Query: BACKUP database `sqlquery_testing` to DISK='C:\_DataBase_BackUp\DB_BackUp Jun 27, 2018\SQLQUERY_TESTING.sql' with format

Error Code: 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 'database
`sqlquery_testing`
to
DISK='C:\_DataBase_BackUp\DB_BackUp Jun 27, ' at line 1

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.001 sec"

and i dont known what's wrong. please help me

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.