[adwade]

First of all, I want to THANK PaulM for taking the time to create this MOD and put up with all the people not reading the THREAD for excellent help information before posting that...

An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I took the time to read ALL 42 pages of this thread last night and this morning, and was quite surprised to find that all the issues seem to have been addressed.(it's just people aren't reading the answers posted here )

I too, got the above error when I first installed the MOD and tried to run a backup, but I kept reading over the various posts and figured out what I had done wrong.(i.e. I needed to use ../../backup as my path to the backup folder)

In particular, I want to THANK SkyCatcher for his l-o-n-g winded post about this problem.

Originally Posted by SkyCatcher

If I read ONE MORE POST about how to set the path correctly or receiving the

Error I'm going to explode!

Setting the correct path for Linux Distributions

I think if his post had been ANY shorter, I would still have been lost, but he kept trying to get his point across, I kept reading his post, and I finally got it!


Also wanted to THANK Sparky5693 for his info about how to create an automatic rolling 7-day backup via this MOD. Works fine!

Originally Posted by sparky5693

For those of you that wanted this to delete old backups, you can change the format it names the saved file to accomplish something close. Using the method below, the output file is named Sun, Mon, Tue... etc. By doing this, it would just overwrite the correct the 7 day old file on each save.

Want to say THANKS to Reven and his bit of code to auto gzip the resulting file.

Originally Posted by Reven

I've added a bit of code into mysqlbackup.php to compress the resultant SQL file with gzip. My database is about 35MB, and it's making it 5MB.

I added it in as he described and when it tried to run, I got an out of memory error. So, upon reading Rogue's post (in reference to a php.ini file and the php memory limit)

Originally Posted by powerful_rogue

Thanks, I'll alter to 64.
He said as he's never used vbulletin before he had no idea what directory it had to go in. I'll check over on vb.com

I too went looking for where the php.ini file goes??

Not being able to find such on vB.com, I returned to vB.org and managed to turn up this post below...

Originally Posted by Marco van Herwaarden

You can create a .htaccess with lines like the following to override some php settings (if host has set to allow this):

php_value memory_limit 32M

Alternative might be to include a line like the following in your config.php (should do the same):

PHP Code:

ini_set('memory_limit', 32 * 1024 * 1024); 


So I just wanted to add that I created an .htaccess file in my forums directory (containing only php_value memory_limit 64M) and then the backup routine ran fine and created the gzip file as well! :up:

Other posts in the thread helped me understand bits & pieces of how this MOD works and I THANK everyone for their informative input, but a special KUDOS goes out to the key players mentioned above. THANK YOU!