For path to backup directory i use file.

$backup['DUMP_PATH'] = '/var/www/vhosts/pctuts.be/httpdocs/forum/backup/';

write permissions backup directory 777

Hi Paul,

Can this mod be used for "Repair & Optimize tables" ONLY?

Thanks very much and have a great day

Nope.

LOL! thanks for the help ;)

Nice hack. What is the cammand to join all the files and restore ?

Can this get all the files and join them into 1 zip file?

Yes & No.

The output can be one file per table OR one file per database (containing all tables).

There is no zip facility.

What is the unix command for joing all the tables to one. I tried copy *.sql backup.sql it didn't work in my server. But it works on my laptop. What am I missing here ?

No idea, I don't know unix that well.

Hi all... first post and I wanted to thank Paul and others on the board for their help! :up:

The Autobackup script works like a dream for me and saves me a lot of daily hassle.

I am also a regular on Cable Forum... I have been helped many times there too!

Keep up the good work. :)

Ok i nstalled it..now what?

so don't back up here?

./forumbackup-05-20-07-85412.sql

Instead of posting this every time you install a new add-on, may I suggest the following:

1. read the instructions, readme file, and any help files included with the add-on
2. read the thread where questions from other users have been posed and addressed
3. if you still have an unanswered question AFTER completing 1 and 2, ask a SPECIFIC question, not just "now what?" - that question is meaningless, pointless, and irritating

The last part of your comment was uncalled for...we all can't be as smart as you when it comes to these things. Thanks for nothing.

I'm giving you advice, not insulting you. How do you expect anyone to give you an answer to a question like "now what?"? It's not even a real question.

It's like saying, "I've just installed vBulletin. Now what?"... How would YOU answer that question?

Again thanks. I will search the forum.

maybe good to have like a test option so could check if it works n stuff? just a idea. i dont relaly need it i dont guess.

forums ddont seem to auto turn back on after its done......

What happened with mine was the page would show the tables being backed up.......but then when it got to my posts table I believe.........it would kinda timeout....and the page would goto a couldnt load page. This is in firefox 2.0.

So after I saw my backup had completed (refreshed in my ftp, and saw the modified datetime didnt change anymore on the sql file -yes im going to change my backup directory later)........so I goes into FF and i reloads the frame. So now what happens is......it deletes my backup and restarts.

My page times out again. So right now Im waiting for this backup to complete again.

Why are you manually running the task ?

Hello

i have read a lot of pages in this topic but i cant find a solution for my problem:

i have installed this product:

i have set:

$backup['DUMP_PATH'] = '/home/httpd/vhosts/pc-helpforum.be/httpdocs/backups/'; // Path to backups folder, with trailing slash

so when i check if it works (press 'run now') i get the error:
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

when i check the ftp folder: 'backups', there is a folder 2007-05-24 generated

all maps are 777 cmod

whats wrong?

"all maps are 777" What does that mean ?

You shouldn't be storing backups in your httpdocs folder as they will be accessible to anyone.

To make sure I had everything right. And....I needed to backup so I could install some hacks. Not good to manually run it?

i mean that the folder Backups has write access,

suggestions?

i will change that

If you run it manually and it takes a long time then you may hit timeout issues (as indeed you appear to have).

Use a relative path in the setting (i.e. ../backups or ../../backups).

i can't see to get it work

the fulle path is /home/httpd/vhosts/pc-helpforum.be/httpdocs

my forums are directly in the httdocs folder

so the map includes is: /home/httpd/vhosts/pc-helpforum.be/httpdocs/includes

i have create the map backups in /home/httpd/vhosts/pc-helpforum.be/httpdocs/backups

so i have set it:

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

also tried

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

suggestions:
sorry because i don't got it work

Sorry, there is nothing I can do about permission issues with your server, which is what you have here.

Do u think?

I can use the backup feature thats included in vb standard - that works very good
but now its not working, weird :-)

Yes, the error you listed tells you that ;

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

That means the webserver did not have write permissions to create the file.

Hi Paul,

i found what the problem was :D

my server was running in Safe Mode,
i've mailed my Hosting company and they putted it off,

now it works like a charm :-)

thanks for the support !

karel

Hm.....well the forum doesnt come back on. Same prob that other guy is having. I have yet to attempt to imiport the database to see if I get any errors, but it looks as if it got backed up ok. I see the whole big 2GB file right there.

Ill let you know what I find, if I find anything. Im not real good at this linux stuff.

Hm....yeah Im not understanding why it doesnt turn the forum back on. I let it go with the option to not turn off forum and to lock tables. My site comes unavailable for about 30 minutes......but.....the backup seems to go fine...and the site comes back up fine too.

:shrugs:

If you lock the tables then the site will be unavailable as vb will be unable to perform any database updates.

Love this hack, works very well
Just a question, has anyone managed to add FTP functionality to it?
I have a remote storage space account, which I use for offsite file backups, so having the database ftp'd to another server, would be awesome

I am getting the following error now:

Warning: is_file() [function.is-file]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 225

Warning: is_dir() [function.is-dir]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 260

Warning: is_dir() [function.is-dir]: Stat failed for /home/username/backups/06-09-2007 (errno=13 - Permission denied) in /includes/mysqlbackup.php on line 271
An error occured during the MySQL backup. Details (Could not open Destination SQL file for writing.)

I have not seen these errors anywhere in this thread (except for the "error occured during.." one). Any thoughts? Thanks in advance.

My first guess would be the directory is write-protected, i.e., you have to set the permissions to 777 or 666.

Am.....

MAZING!

After months of trying, it finally works! Yes! Thank you!

Ah, how amazing it is to finally have a good host. :)

I got a php friend of mine to modify this to send the backups to a remote server
Would it be ok to post the modifications here?