Hello, need some simple advice, here is the thing:
I need to back up mysql database and I plane to do it in the following manner:
1. Dump the database into the file
2. scp it to the ssh sevrer (from here the existing backup software will pick it up)
The question is how do I dump mysql db to the file? (shoudl I stop mysql before dumping?)
Thanks,.