Good way to automatically backup a database.

[aimeeandbeatles]

Since my disaster Im going to be more careful about backup of my database. Anyways I could do it manually but I'm sort of lazy.

So doing it automatically to dump to a folder on my hard drive would be nice. Any suggestions? I am using WordPress if a plugin would be sufficient.

 

[aimeeandbeatles]

I found a way to do this.

I installed a plugin that automatically backups the compressed (gz) database into a directory (it's protected OK by htacess and stuff). Then I found a program that will automatically mirror on my local folder drive the contents of that directory and I have it set up with a batch file and the task schedule do it once a week.

 

[innonimatu]

Depend on the database, but every one has one or more backup tools. Ideally you should backup a dump with both the db structure and the data. Backing up the actual database files is not a best practice, but I guess it'll work too, if your environment is static.