I have a vps with ubuntu 9 server.
I need to backup my MySql database.
Can MySql make backups automatically? If so, how?
If not, how should I do it then?
The website is a classifieds website (PHP, MySql etc)
Generally you just write a script to it and put make a cron entry for the script so it runs as often as you want. There are a bunch of examples here.
Database Backup Crash Course for a Programmer:
You make database backups of MySQL databases by using the mysqldump command. You would simply create a cron entry that would execute the mysqldump command.