I'd like to do MySQL dumps against a Crystal PM install I've inherited.
I've noticed that the backup method is one of stopping MySQL service, copying the data off, restarting MySQL. This results in large 17+ GB archives that choke our nightly backups.
I'd much rather do native MySQL dumps, since:
A) They'll compress better B) Our backup software has MySQL support so sending off the dumps will be much quicker, since only deltas will be sent up to our backup server C) It's the preferred method for backing up a MySQL database in native SQL format
What is a username and password which will allow us to run native MySQL dumps against the Crystal PM database?