How to backup mysql database using query

Question

BACKUP DATABASE dbwebsite TO DISK 'C:\Users\Paeng\Desktop\mydatabase.sql';

It always says error

Query : BACKUP DATABASE dbwebsite TO DISK 'C:\Users\Paeng\Desktop\mydatabase.sql'
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 dbwebsite TO DISK 'C:\Users\Paeng\Desktop\mydatabase.sql'' at line 1

check syntax. Review mssqltips.com/sqlservertutorial/20/… or learn.microsoft.com/en-us/sql/relational-databases/… — Rajat Jaiswal
– Rajat Jaiswal, Commented Jan 3, 2019 at 10:55
@RajatJaiswal the links you provided is for MS SQL Server. He is asking for MySQL — Code Pope
– Code Pope, Commented Jan 3, 2019 at 11:22

Code Pope · Accepted Answer · 2019-01-07 12:33:45Z

1

To the best of my knowledge there is no SQL Statement for MySQL database to backup anymore like the syntax you are using and which is possible for MS SQL Server via TSQL.
For MySQL you have the following options to backup your database:

Use mysqldump as a logical backup tool
Use MySQL Enterprise Backup if you have MySQL Enterprise Edition.
You can copy the MyISAM tables by just copying them.
You could also write a SQL script and copy the content of the tables into txt files by using the command: SELECT * INTO OUTFILE 'fileName' FROM tableName
You could of course also use replication or file system snapshots.
If you want to backup the database using vb.net (as mentioned in comments), you can use the following MySqlBackup.NET, which is an alternative to mysqldump. The web site and documentation can be found here: https://github.com/MySqlBackupNET/MySqlBackup.Net

For more info read the MySQL documentation: here.

edited Jan 7, 2019 at 12:33

answered Jan 3, 2019 at 11:33

Code Pope

5,4598 gold badges32 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

B_CODE Over a year ago

thanks, #4 perfectly work but i need to backup database using query or using vb.net platform

Collectives™ on Stack Overflow

How to backup mysql database using query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related