creating a backup file

Realme

Active member
Joined
Jul 2, 2019
Messages
33
Programming Experience
Beginner
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?
 
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.
 
Back
Top Bottom