I have a question about the backup path in the mysqlbackupconfig.php-file, I could not find the anwser in previous posts:
I currently use this code and it works just fine.
The DIR point to "www.domain.org/forum/" and my backups works just fine.

However, I would like to backup to a folder outside the forum-folder. But I have not managed to get the syntax right. Naturally, I created the folder 'backup' on the server before editing the config-file.
I get the following error messgae : I have tried several alternatives (see below) but none has worked.

Is it at all possible to make the script to write the backup outside the forum-folder, and if yes,

Use '../' to move 'up' a level.

e.g.

or

Thanks for quick help! Worked just perfect! :up:

Got this error when trying to run the backup:

Fatal error: Cannot instantiate non-existent class: mysqlbackup in /home/.../public_html/forum/includes/cron/cronbackup.php on line 19

Have you uploaded all the files, to the correct place ?

Yes

mysqlbackup.php
mysqlbackupconfig.php

in forum/includes

cronbackup.php

in forum/inlcudes/cron

Then I have no idea - the class is clearly defined in mysqlbackup.php

Have you edited any of the files ?

So This Auto backup ur forums???

can u give me some more details like where it saves and other stuf plz

the whole thread (5 pages) is about this stuff.

you might want to read before you ask...


PS still have not got it working. figured out that the error message returns an array of possible write locations, separated by colons. Whatever I put into the 'dump to' path, the paths shown in the error message remain the same.
the array is as follows.

I don't really think these dirs are hardcoded into the php configuration, so somewhere between php input and file output, things just go wrong...

[edit]weird thing is that the adminCP backup function works like a charm. file gets written to the root nicely (mind you, the root is in the array above! perhaps it would work if the cronbackup would try to save the files to my document root?)[/edit]

open_basdir is a php setting that restricts what folders you webserver can write to - you need to speak to your host about that.

What is the preferred method for the most successful VB backups and restores, tables as single files, or all tables in a seperate files?

Installed and working a dream on Win2003 installation!

I use seperate files so I can easily restore just one table if necessary. For a full restore you can just join all the files into one.

Freaking Nice! Thanks for this MOD, I am feeling a lot better with this running daily!

:)

One thing that would be nice would be auto-deletion of backups after a certain length of time.

agreed! +1 On Auto Delete after certain length of time.

Hi!
First of all, thank you for the hack and for your great support.

Now to my problem.

I got this error:
The folder with the "date" is built in my backup folder but there is no sql file in it.

Help!

I have tried dozens of times to do backups manually, but I get the error that many are getting. What else can I do?

My backups folder is in the root. What I have, then, is something similar to this:

$backup['DUMP_PATH'] = '/home/sub/scxxxx/backups'; // Path to backups folder, with trailing slash

I have chmoded the folder to 777. I have tried disabling and enabling the product again. I have completely uninstalled it, only to install it again. I have moved the folder all over the place, changing the path appropriately, and still nothing. I followed SkyCatcher's suggestions in post 210, and still nothing. What else is there to do?

Thanks SO much! :)

This morning was the first automated one that happened, all went well, the only problem I had, or am having it did'nt turn the forums back on, I just realised now at 8am that the forums were still turned off after a 5am backup!

How can I check and ensure that does'nt happen again?

Look at what it says ;

Now look at the path you have entered and correct it. :)

Yip 2nd automated backup and I have to manually re-activate the forum using options, again the backup worked like a dream, but left the forum closed until I noticed it.

So this will be a critical issue for me to get solved.

The only solution is not to use the option to close the board during backups.

Ok I will change that, will this be changed soon?

Just had a thought, is it not an option to schedule another task say 30mins later to reopen the forum? How would I do that though?

For those who have cron access, you might want to look at AutoMySQLBackup. It backs up all mysql databases and does daily, weekly, and annual cycling on a cron.

(this is still a great tool for those without cron access)

(also...any tool to help automate backups is a great thing....life can become very miserable when you don't have a recent backup)

Paul,

Thanks for the help. I am sure you must be beating your head against the wall after having the same question asked time after time. I would do the same! Since I want to be compassionate, let me give you a pillow to put between your head and the wall, because here comes another question!

I changed the path to:

Yet I am still getting the same error. From reading the posts my understanding of adding the trailing slash is the slash I added at the end. I will reread some posts in the meantime to make sure I am correct in this regard, but if you have some time, I would appreciate your help oncemore.

Thanks again for the help and for your patience. Truly to be admired.

That looks like an incomplete path to me. On most servers, it would be more like:

Also, make sure that the backup folder is write-enabled.

You may be better off using a relative path (e.g. ../../backups/).

Also make sure no open_basedir restrictions are in place, preventing writes to the folder.

this is what I use:

Works well and forums even open themselves again :D

Thank you Paul,

This is working great on all my boards ..

Could you please update the $Backup[message] to tell my visitors that "we finished backingup such and such tables out of total of such and such?

Sorry, that is not possible.

No problem Paul ..

You're right .. That might reveal some database secrets to others ..

Please forgive my ignorance if this was asked:

Will this system recycle every number of times (able to remove older backups it created)?

Or should I add a server-side cron job to do so?

No it doesn't do that but it would be an excellent addition. Post 'em if you got 'em. :)

Thanks odie3 that worked like a champ!

Great product clicks install :)

Hello,
i'm sorry if is a very basic question...
I read
How i can join the sql files?
and...
I can restore by phpmyadmin?

Tks in advance
and all the best

Joao Barroca
aka beduino

the question of restore by phpmyadmin the answer is yes ;) i already test
the remain question is about join sql files. Or, maybe, a option to backup one sql only...
all the best
and tks again

You join them using your OS (e.g. DOS Copy command) or any program designed to join files. The option to backup to one file already exists.

Sorry,
I see now ...
Tks for your time and support
B.

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

That's almost always one of two things:

1. the path to your backup directory is set incorrectly

2. the write permissions for the backup directory are set incorrectly