creating a backup file

[Realme]

I am stuck with creating backup file. I am inside my database "publication" logged in as "jim" password "mypasswd" I try the following bellow but i only receive error code.

mysqldump -u jim -p mypasswd publications > publications.sql;


ERROR 1064 (42000): You have an error in your SQL syntax;

what did I wrong?

 

[JohnH]

Be aware this is a C# forum. You can use for example this library in C#: GitHub - MySqlBackupNET/MySqlBackup.Net: A tool to backup and restore MySQL database in C#/VB.NET/ASP.NET.

 

[jmcilhinney]

To reinforce what JohnH said and also what I believe some others have said in other threads, this site is about C# development, so the MySQL forum is intended for questions related to using a MySQL database in a C# application. If you want to use C# code to create a MySQL backup then that is a relevant question here. Using MySQL independent of C# code is not relevant here. The fact that you may be using that database with a C# application does make backing up that database independently of that application relevant to this site. We encourage you to ask all your relevant questions here but also to keep the questions you ask here relevant.