I know that its not a permission issue now. I can go to my admin panel and do a database backup manually and it can write an sql to that folder. If I try it with this mod with the paths the same it doesnt work.

Oddly when the backup task runs javascript (vbulletin_menu.js) is stripped from all the forum pages and as a result javascript of any kind doesn't work anymore. I've narrowed down the problem to this modification - it doesnt occur with any other.

Any idea's what's happening and how to fix it? What i have to do now when this happens is either disable & enable plugin hooks or use a template cache plugin that refreshes the template cache. When i do either of these things javascript works properly again.

Try turning off the auto closing of the forum during backups.

Thanks for the fast reply.

I edited the file. Hopefully tomorrow morning when it runs it won't break JS again.

I have to ask this... Paul, why do you need 3 files to do what one file can do alone? I have been using a single file backup since 3.5.4 and it has always worked great and still does in 3.7.0. I'm just curious is all. ;)

You'd have to ask Trigunflame that question.

Paul, you're telling me you don't know? As good a coder as you are, you could do it all in one file.

dose It support utf-8 encoding?

I see no reason to change it.

I figured that would be the answer. ;)

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.

change mysqlbackupconfig.php

change this
to this
Remember... you'll only have 7 days of backups on hand like this. If something goes wrong, you need to get to it before your backup is overwritten.

Well, I was able to get it to work, but no matter what path I put in, it saves it to the public directory.

Dangit.

Sweet. I set permissions so nobody can see the folder, but this can write to it...

Excellent.

What is the best setting to put so it can write but nobody can see your backups?...

Forget it. I used ../Backupfile

This brought it off the public file. Now they have no access.

However it works on chmod 722, which allows it to write, but nobody can really see it, unless you are logged into your CPanel, if you can only load it to a public file...

Thank you.... :up:

I've been doing it manually.... :)

Does this also work for file-by-file mode (table by table?) , besides one single file?

Regards,
Badger

Yes, it should do.

Thanks Paul ... :up:

I made the change this morning, although at this point I left it for singles file, so I'll see what it does tonight...

Regards,
Badger

Hi Paul,

I have a few questions, hope you can help me :)

The first one is about the parameter to shutdown the forum during backups. Why I would need to setup it to '1'? It makes backups more reliable? Do you recommend to shutdown forums during backups?

The second is about the lock tables during bump. The same question... it makes the backups more reliable?

And the three one is related to split backups in independent files for each table. I manually download my backups everyday and it's easier for me to make the backup in one unique file... it's a bad practice to backup in one SQL file all the tables?

Finally, how I tell you lines above, I download my SQL backup file via FTP. It's secure to download my backup file using FTP? I heard about it's better to use SSH to download a backup file :confused:.

Thank you for your time... and your patience :D

Paul, it worked! So far javascript hasn't disabled.

Any idea's why it was disabling it when "close forum" was enabled?

1. There is no need to close the forum, I don't (and in rare cases it can cause issues - see below).

2. Again, there is no need to, and it will stop you forum being used while the backup runs.

3. Its purely personal preference.

4. I use FTP, technically its more insecure, but in the real world its not likely that anyone will intercept your download.

Yes, the way the current system works appears to occasionally screw up some vb options.

Paul, thank you very much for your reply :up:

Question, my path is this (to my FORUM):
/home/mysite/public_html

Can someone please reply back to what new directory i should create to store my backups in? Should it be something like this:
/home/mysite/BACKUPS ?

The mysite folder contains 2 folders, one is public_html and other is certs

This is linux server btw.

Yes, that would be a good choice.

to stop it from shutting the board while the backup is in progress do i make the following changes?

change: $backup['SHUTDOWN'] = 1;

to: $backup['SHUTDOWN'] = 0;

Yes.

so this will make a new folder and backup file for each day correct? or will it continue to overwrite the 1 it makes?

That depends on how you set up the time in the config. It will overwrite anything of the same name.

Paul im stupid, explain to me what i would have to do if i want to have the backup create a new file each time the backup runs?

EDIT: Nvm fixed.

i have problem with persian(farsi) (utf8) character, when i restore the specific table, it restore question marks "?????" instead of orginal persian(farsi) characters. something like : تست == ؟؟؟

As soon as I disable this product, the hover feature comes back. :confused:

Paul is it possible you could write a script to just force a repair/optimize every set minute/hour/day type deal? I ask because that is in this script when it runs the backup.

Thanks in advance

There is no valid reason to want to repair/optimize mysql that often. Its only in this because the original author added it, and I have never removed it. :)

Okay...thanks for the reply.

I've skimmed through all of the posts and I apologise if this is mentioned previously..

On my instance, if you're the person unfortunate enough to kick off the database backup you are presented with the output from the backup script. Is there any way to turn this off?

I'm pretty sure that should never happen. Sounds a bit odd to me.

thank you nice

Hey Paul M, thanks for this. This works like a charm.

I'm going through my plugins now and getting my site 3.7 ready. Is this expected to be 3.7 compatible?

There is a 3.7 version in the 3.7 forum.

Thx, installed that one and it works like a charm just like this one. :up:

This may have been answered, but i cant find it.
After downloading the backup, i find it has saved all the tables seperately. I now want to update my mysql with a complete backup, but this will take forever with all the seperate files.

Is there a way to join all the files or install all in one hit??