Best Practice for backup location

[samona]

Based on best practice, what directory is used to backup databases?  Do you have to create your own, or is there a specific folder in Linux where you should store your sql files?

[aschk]

Specify the backup directory yourself. We don't know where you want it

[Maq]

Doesn't matter, it's for your own good.  I personally just have the backup folder in the same directory as to what I'm backing up.  I keep it the same folder structure as well.  But if you're backing something up like a database I usually just date it like this, "091908.sql".

[corbin]

I always [if possible] put any kind of backup on a different physical drive.  Drives don't die that much anymore (although still happens in heavy load environments enough to be a concern), but I guess I'm just paranoid.

 

 

Edit:  I worded that badly....  I meant that drives aren't likely to die in my personal situation, where I have low read/writes and so on.