That depends on the shutdown setting.

So what your telling me is I can set it so it will not shut down the forum at all and still perform the backup with no problem? Also will it delete the old backup file once the new one is created?

Yes. That's how I run it.

No (unless the backup file name is the same).

ok thank you for your help

Not Installed Paul...no working, sorry

If installed like it says in the readme and when i try and run the task it says

but i dont understand why its saying it cant open the sql file, I dont want it to open it I want it to make 1 and save all the tables there :S

Iv set it to save to /home/(username)/backup which is chmoded to 777

Can anyone help?

1. That error means it isn't able to open a new file to write the backup. Since you've already said that the current backup directory is write-enabled, I'd assume it can't find the directory you've specified.

2. See if it will work under the forum directory - it may be balking at a configuration above the forum root.

I fixed it! Turns out it didnt work because I forgot the / at the begining on the file path :P Thanks djbaxtor

can this script be set to do multiple back ups a day?

im looking at vb scheduled task and I am trying to figure out how to set my backup to do a backup every 4 hours but I can't figure it out. any help would be great. Thanks

I don't think you can set a vb cron to run every 4 hours.

What is the point of this if I can backup my db in phpmyadmin?? or in terminal??

1. it's more convenient/easier

2. it's automated

Ok I know this may be a lame question but I am new to this so here it goes...

I am trying to make the back up folder but I dont want it to be seen by the public... where in the root do i put it so the public cant see it. are all the forum folders able to be see by the public?

my root is
sitename/

all those folders after the / are able to be seen correct?

sorry for the questions but I am just new to this

thanks for the help

If you can't see the point then you don't need to worry about using it .....

I asked because I didn't understand what this was alright?..now I understand and it makes sense on what it does..maybe with a little more info I would of understood everything from the beginning.

I have a question.. is there ANY way of having this SAVE my db+tables into one .sql file and NOT just the tables themselves??

and is it ok if I made a .htaccess file with "deny from all" inside the path/to/backup path?

1. Just set the combine setting to 1

2. Yep, that should stop anyone accessing it.

Thank you :), working nice!

Hello, I am a new guy and this is really great. The only problem is that I can only get it set up right to a folder below my forum. I have been up and down this thread trying everything but I can't seem to get it set up right. I am in shared hosting and I have read to check in phpinfo and all I can find is /usr/local/Zend/etc/php.ini I am trying to go off my root folder to admin/backups. Any suggestions? I guess maybe I'm getting too old for this.:)

Check with your host - I would guess they have restrictions in place to stop you writing to folders outside of your web root (assuming that's what you mean).

Thank you for the reply. I am trying to write it to /admin/backups/ from my root, starting folder. I have been trying to do it by /../../admin/backups but nothing seems to work no matter how many dots or slashes I put.

I'n new at this so sorry If I don't make much sense.

Ok sorry for the newb question but I have configured the mysqlbackupconfig.php and uploaded the xml file.. how do I adjust the timing of the back ups. I dont see anywhere this product in my Admin CP. How do I make the program run?

again sorry for the lame question, I am just now starting to figure Vb out.

thank you

Look in the admin cp under scheduled tasks and scheduled task manager. It should be called database backup. You can click edit for scheduling or click run now to see if it's working properly.

After two MySQL crashes in one week I was looking for a good backup solution and this does the job very nicely.

Between this hack and using WS_FTP's Synchronize utility I have a fresh backup on my local PC daily now. Eventually I'll do something to remove the old backups on the server but for now the solution is working nicely.


(And, looking the backup size of each individual table, I spotted a few things that I don't think would've normally caught my attention. Things like a 2gb ModeratorLog table! :eek: )

I thought you might want to know that this version doesnt work with vbulletin 3.7.0 BETA 3

This isnt the only hack that doesnt work but i get this error...

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = prefixrequired

Sorry but that error has nothing to do with this modification.

Paul,

For some reason this mod didn't run properly today. I started run for a while but never finish or end it. I set to close the forum when it back up, but 5 hours after it run the forum still close. So I when to task scheduler and run it manually it run ........ but then it never finish. Usually when it finish i going to say finish, with 0 error now it doesn't say that

Everything was working fine since 16th dec. Until I noticed the forums stayed switched off for an unusual amount of time today. So I turned vB off, then on again to enable the forums. Ran the scheduled task manually and I got the following sql error and the forums got switched off and stayed off...

The error is pretty self explanatory - something (else) has locked the datastore table, preventing it being updated.

Figures... How do I unlock it? I mean, if I manually run the task, it shouldn't be any different to a scheduled run correct? When ever I manually run the script the datastore is always locked. So I would assume it is or has been permanently locked. How would I remedy this?

Thanks Paul.

This mod kinda ruins your skins, I noticed that after a few restores so if you had this problem, don't worry, just rebuild your styles on the "Update counters" and rebuild your styles and everything will be fine
--------------
Paul, is there any way to run this mod more than one time a day? If so, can you guide me please?

There is no way I can tell you what is locking it. Something has a read lock, the message is a bit odd to me because normally I would expect mysql to just queue the write, and process it when the read lock has gone.

This mod cannot effect skins as such, its read only. My guess is you store your css in files so you need to rebuild those files after a restore.

You can run it as often as a VB cron will allow (hourly if you want). However you will need to change the Time setting in the config so that the files have a unique timestamp, otherwise each run will overwrite the previous.

I have moved folders around on my server and all the files and folders are set to 705. I'm sure it has to be 755 or something? Could this be the cause?

Fixed: incorrect dump path in mysqlbackupconfig.php

I have a strange problem with this hack. Each morning after this runs, the hover preview does not work (when you hover over a thread name and get a preview of the thread). Any clue what this might be conflicting with? thanks.

There is no way this could have any effect on that.

I thought it odd as well but disabled it and didn't have the problem anymore. After a week or so I enabled it again last night and this morning had the same issue. ?

Excelent mod. Installed. Thank you Paul. Regards.

So how do you fix it ?