I've been looking for examples on how can I backup my mysql database using 'mysqldump' command. I saw many examples and tried their advice but none of can solve my problem. I just getting confused how to use mysqldump.
I want to backup a database only so I try this,
Code:
mysqldump -uUsername -p password --databases database> c:\database.sql
So I type like this
Code:
mysqldump -root -gis --patient > c:\patient.sql;
or like this one
Code:
mysqldump -uroot -pgis -- databases patient > c:\patient.sql;
but none of it working. Help me please