Backup my MySQL databases automatically

[khalled]

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 '

[Outbackmark]

Use this mod https://vborg.vbsupport.ru/showthread.php?t=201319 and you can then compress the files via cpanel/file manager and delete the uncompressed file to save space.

[snakes1100]

If this is a VPS, then you "SHOULDN'T" be backing up via any plugin or php script, but thru SSH or a cron script.

Please search Google for a simple shell script to dump your db's, gzip them and place them in a directory of your choosing.

[Outbackmark]

I have a number of sites on a VPS linux and use php scripts for backups all the time, what's the drama with using PHP on a virtual dedi?

[snakes1100]

The fact that a php script can and will time out and give you INCOMPLETE backups.

[Outbackmark]

Yes granted, but it is pretty simple to alter your timeout settings and the backup via a decent php script is so fast that your DB would have to be a giant to run into that problem anyway.
My largest database is over 280 megs and I have yet to alter the php timeout settings or get an incomplete backup.

[khalled]

I have a number of sites on a VPS linux and use php scripts for backups all the time, what's the drama with using PHP on a virtual dedi?
can recommended one for me
The fact that a php script can and will time out and give you INCOMPLETE backups.
yes that happened with me while i restor my database

[Outbackmark]

What method of restore were you using?

[Dismounted]

The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php