General discussion

Locked

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

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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums