How to Back Up MySQL Databases From The Command Line

Question

Hi How to Back Up MySQL Databases From The Command Line in .Net core I am using this syntax: @mysqldump -u -p databaseName> ' + backupDIR + \ + dateTime.Now.ToString(ddMM) + .Sql' I got an error 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

Nitin Bhardwaj · Answer

I have already tried.

YOGESH KURNE · Answer

for single database you can use mysqldump database_name>database_name.sql and if multiple databases is there then mysqldump --databases database_one database_two> two_databases.sql try these..........!

Manikandan Murugesan · Answer

Sir  Refer the following Links : https://www.liquidweb.com/kb/how-to-back-up-mysql-databases-from-the-command-line/ https://www.tecmint.com/mysql-backup-and-restore-commands-for-database-administration/ http://www.fastwebhost.in/blog/how-to-backup-mysql-databases-via-command-line/