Backup my MySQL databases automatically

I won't to backup my vbulletin 3.8.2 database automatically (daily,weekly, ...,) , the forum database size more than 120 megabyte and i have Linux VPS Server

 

Well if u have ssh access make a simple .sh file and setup a cron

 

If you have cPanel server you can also set daily, weekly and month backup for your entire site.

Kailash

 

how i can make .sh and setup

i use Plesk

 

You don't need to create an .sh file. In your crontab, you can simply call a mysql dump:

mysqldump -u dbusername --password='dbpassword' username_dbname > /home/username/file.sql

 

Some more ways to backup mysql dbs:

http://www.ezlinuxadmin.com/2009/03/10-ways-to-backup-mysql/

 

Well actually doing that would just rewrite the old databese over the new one

 

That would rewrite the backup file, not the database itself. If you wanted to do daily, weekly, monthly, all you would need to do is create different cronjobs that are called at different times, and dump to a different file. ex: daily.sql, weekly.sql, monthly.sql