I am looking to do a backup of the ubbthreads database and ftp a copy of it to another server for offsite storage.<br /><br />I would like it to dump the database to a file in a directory that I configure in the script that would be named "databasename-date.sql" it would then gzip the file and then it would ftp it (with specific account settings) to a folder on a different server for safe keeping. It would also be nice if it had a rotation feature where it would only keep the last X number of back up files and delete the older ones. This would be nice to put into a cron job and just have it run everynight at 4am or something.<br /><br />Anyone know of anyway to do this or something that can do this?<br /><br />Thank you!

phpMyBackup is perfect for this - it makes zippled mysqldumps - you can setup a cron to do it automatically. You can download them from the directory on your server and/or FTP them to another server.<br /><br />I run this as an added "offsite" backup for my consulting clients who also host on vetex. <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /><br /><br />http://www.ubbdev.com/forum/showflat.php?Number=106649#Post106649

Josh this looks like exactly what I need. I downloaded it and installed it but when I run it I get this error. <br /><br />Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 5323 bytes)<br /><br />Simple fix?<br /><br />Thank you!

Hrmmm.... if the database takes too long to dump, then you'll need to increase the max execution size in your php.ini file.<br /><br />If it's not your server, and you can't change the settings, then you'll find some programs in this thread on servers where timeouts are a problem.<br />http://www.ubbdev.com/forum/showflat.php?Number=116768

I changed the settings in my php.ini and it worked like a charm. Thank you for pointing that out!