I'm looking for a great solution to backup my MySQL databases - all of them. I'd like each one in at least it's own file. I need FTP ability later, but not right now. Right now I just need it to save on the same server that it's running on.
What do you use?
I suppose I should be clearer in what I'm asking for... I'm looking for a bash script that will utilize
mysqldump to creat individual backup files for each database or an individual file for a table if the table is large enough.