vB Database Backup Pro (Lite) for vb 3.6

[Paul M]

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).

[chingon]

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.

[Sevo]

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

[chingon]

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.

[KW802]

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: )

[silvermerc]

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

[Paul M]

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

[taydu]

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

[SpArKs85]

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...



Database error in vBulletin 3.6.8:

Invalid SQL:

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('options', 'INSERT LARGE AMOUNT OF DATA', 1);

MySQL Error : Table 'datastore' was locked with a READ lock and can't be updated
Error Number : 1099
Date : Sunday, January 6th 2008 @ 05:56:39 AM
Script : http://www.tricksofthetradeforum.net/admincp/cronadmin.php?do=runcron&cronid=21
Referrer : http://www.tricksofthetradeforum.net/admincp/cronadmin.php?do=modify
IP Address : ?????????????
Username : Tag
Classname : vb_database

[Paul M]

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

[SpArKs85]

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.

[edgecutioner]

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?

[Paul M]

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?
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 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
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.


Paul, is there any way to run this mod more than one time a day? If so, can you guide me please?
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.

[SpArKs85]

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.


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?

[SpArKs85]

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

[afullcup]

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.

[Paul M]

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

[afullcup]

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. ?

[pedroenf]

Excelent mod. Installed. Thank you Paul. Regards.

[Paul M]

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. ?
So how do you fix it ?

[LorinPotter]

Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA

[djbaxter]

Something I didn't find anywhere in this thread is how do you use this backup to do a restore?
TIA

You don't. You import the SQL files via phpMyAdmin.

[Paul M]

or better still, using SSH (if you have access).

[peterpigman]

Will this work on a large db 400+mb?

[Paul M]

Yes.

[Caerydd]

Installed, running beautifully on 3.6.8 RL2. I actually made my own scheduled task, as I didn't realise the hack had already made one, but it's all working great. Thanks very much!

[GateKeper]

Installed and ran this manually, got this error

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

in the mysqlbackupconfig file I used the /backups/ directory, I know this one exists on the server at the root level and I have insured it's 777, seems I am close,,,but still not working...

any further ideas are appreciated...

When you get the time..

Thanks

GK

[franzjuve]

Installed, running beautifully on 3.6.8 RL2. I actually made my own scheduled task, as I didn't realise the hack had already made one, but it's all working great. Thanks very much!

Thanks for feedback ;)

i installing too in my 3.6.8 ;)

[Animparadise]

thanks paul , realy great backup system.
is there any problem to do not shutdown forum in backup progress?

if so , just edit : $backup['SHUTDOWN'] = 1; to $backup['SHUTDOWN'] = 0;
??

[Paul M]

I dont use the shutdown and have never had an issue.

[scoobasteve]

I have a dumb question, maybe already been posted before. But what's the difference between this hack and the original backup that ships with vB by default?

[Paul M]

No idea.

Although you can't schedule the default vb one.

[GateKeper]

Installed and ran this manually, got this error



in the mysqlbackupconfig file I used the /backups/ directory, I know this one exists on the server at the root level and I have insured it's 777, seems I am close,,,but still not working...

any further ideas are appreciated...

When you get the time..

Thanks

GK

sorry to bump, but is my above line not correct ? I even created a new folder, still no go.

[Paul M]

I cannot help with individual security issues on servers. Your web server does not have permission to write to that folder. Speak to your host.

[nuno_oliveira]

Hi

I have a vbulletin forum that was converted from a phpBB forum. After the conversion the attachment database database table was much larger than the original and now my database has 1,8GB. I need to make a backup, I have tried with this mod, but I got this error


Database Backup
Processing access : Total Rows = 0
Processing adminhelp : Total Rows = 1394
Processing administrator : Total Rows = 2
Processing adminlog : Total Rows = 6155
Processing adminmessage : Total Rows = 0
Processing adminutil : Total Rows = 1
Processing adv_modules : Total Rows = 22
Processing adv_pages : Total Rows = 1
Processing adv_setting : Total Rows = 122
Processing adv_settinggroup : Total Rows = 3
Processing announcement : Total Rows = 2
Processing announcementread : Total Rows = 386
Processing attachment : Total Rows = 3443

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 33554431 bytes) in /home/rexfilen/public_html/forum/includes/class_core.php on line 665

[sundarmobiles]

thanks paul thanks for the mod its realy working well in VB 3.6.8 pach level 2 but i have one doubt is it possible to make backup more than 150,200 mb is it possible?.................................

[Paul M]

There are no size limits, but what exactly is 150,200 mb ?

[peterpigman]

How can you check this has done a complete backup? I know my Db is 400+mb as we moved recently, but the backup is only listed as 295mb.

[sundarmobiles]

There are no size limits, but what exactly is 150,200 mb ?


am not asking exactly like 150,200 mb etc,etc,............... like this

[Paul M]

My database is well over 500mb.

[peterpigman]

How can you check this has done a complete backup? I know my Db is 400+mb as we moved recently, but the backup is only listed as 295mb.

?????????:confused:

[sundarmobiles]

My database is well over 500mb.

ur database is including attachments or without attachments....................................... ...

[Paul M]

Without. We store them in the file system.

[Paul M]

?????????:confused:View the files.

[Harley D]

O.K. I installed this and it works!, Thank you!!!

Now for the bad news....

My site has been hacked and the posts have been deleted.
What do I need to do to restore them, using the backup this mod made?

Thanks.

[peterpigman]

O.K. I installed this and it works!, Thank you!!!

Now for the bad news....

My site has been hacked and the posts have been deleted.
What do I need to do to restore them, using the backup this mod made?

Thanks.

At a guess I would imagine you need to go to phpMyAdmin and import the post table

[Paul M]

Basically as above, to restore you must import the data back into mysql, using whatever methods are available to you (ssh is best).

[Harley D]

Thanks, for the help and the mod.

[Robbey]

Database Backup

Parse error: syntax error, unexpected T_STRING in /home/tecki/public_html/includes/mysqlbackupconfig.php on line 15

What do I do now?

[Paul M]

Fix the error in your config file is what you do. :)

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

[Robbey]

Fix the error in your config file is what you do. :)

Whatever you edited (on line 14 I would guess) has a mistake in it that you need to correct.

I didnt edit anything in that file though.

[Paul M]

Then your file is corrupted. There is no such error in the proper copy.

[Robbey]

Then your file is corrupted. There is no such error in the proper copy.

I was using notepad, I used wordpad and it made it better, kept on having whacky characters for spaces.

Thanks. Great hack. Worked with no errors.

[sparky5693]

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.

If you want to do the same, here is what to do. Please note, though, that this will only work if you have chosen to combine all data into one SQL file and not split each table into its own file.

File: ./includes/mysqlbackup.php

FIND (lines 525 to 527):
// Free Memory
$this->MYSQL->free_result($rows);
}
ADD BELOW:
// Compress file
if(extension_loaded('zlib') && $this->COMBINE)
{
echo "Creating gzip file from SQL file<br />"; vbflush();

$file = fopen($this->FILE, 'r');
$data = fread($file, filesize($this->FILE));
fclose($file);

$file = gzopen($this->FILE, 'w9');
gzwrite($file, $data);
gzclose($file);

rename($this->FILE, $this->FILE . '.gz');
}
You must also have the zlib extension compiled into PHP. Most shared hosts will have zlib installed as well as most PHP installations in general. The script will not attempt to compress the file unless zlib is installed. You can find out if you have zlib by entering the Admin CP and going to Maintenance > View PHP Info and looking in the Configuration Command section for '--with-zlib'.

If I start using this, and merge all sql data into the one file as mentioned, do I need to make any other changes to be able to use the backup this will create?

[92GreenGT]

I had this working before, but now that we switched servers I can't figure it out to save my life.

Here is what I have as my path in the backupconfig file:
'/var/www/vhosts/mysite.com/httpdocs/back-up/'

Is this not right for a path? The folder is CHMOD to 777, so techically it should work correct?
I still get the error when I go to "Run Now" on the scheduled task manager. On the main page of the admin panel it says "Server Type - Linux Safe Mode". Does this have any reason as to why I can't get it to work? Thanks!

-Edit-
Where it says mysite.com, I actually have my forum url. I didn't want someone to mention that as a problem, lol.

[Paul M]

Based on that, "../back-up/" should work.

[92GreenGT]

Still doesn't work:

Database Backup

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

Whats weird, is it seems to make a folder for the backup inside the correct folder, but there is never anything in the folder? If it's creating a folder inside the correct folder, wouldn't that be the correct path?:confused: I can't understand why it would make a folder with the date but be empty? Thanks!

[Paul M]

Sorry but i cant help you with server permissions, talk to your host.

[92GreenGT]

Sorry but i cant help you with server permissions, talk to your host.

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?

[Paul M]

So thats why its making the folder but not putting anything in it becuase its not allowing it to write?
Correct, your server is not allowing the write operation.

[92GreenGT]

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.

[|Jordan|]

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.

[Paul M]

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

[|Jordan|]

Thanks for the fast reply.

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

[Boofo]

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. ;)

[Paul M]

You'd have to ask Trigunflame that question.

[Boofo]

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

[https]

dose It support utf-8 encoding?

[Paul M]

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

[Boofo]

I figured that would be the answer. ;)

[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.

change mysqlbackupconfig.php

change this

$backup['DATE'] = 'Y-m-d'; // Backup file date format

to this
$backup['DATE'] = 'D'; // Backup file date format

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.

[Phaedrus]

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.

[Phaedrus]

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...

[BadgerDog]

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

$backup['DATE'] = 'Y-m-d'; // Backup file date format

to this
$backup['DATE'] = 'D'; // Backup file date format

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.

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

[Paul M]

Does this also work for file-by-file mode (table by table?) , besides one single file?
Yes, it should do.

[BadgerDog]

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

[jscieza]

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

[|Jordan|]

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

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

[Paul M]

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:

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.

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

Any idea's why it was disabling it when "close forum" was enabled?
Yes, the way the current system works appears to occasionally screw up some vb options.

[jscieza]

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

[Pirat3]

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.

[Paul M]

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 ?
Yes, that would be a good choice.

[F0xy]

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;

[Paul M]

Yes.

[GoTTi]

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

[Paul M]

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

[GoTTi]

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?

[Arrogant-One]

EDIT: Nvm fixed.

[Animparadise]

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 : تست == ؟؟؟

[afullcup]

So how do you fix it ?

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

[Tom_S]

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

[Paul M]

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. :)

[Tom_S]

Okay...thanks for the reply.

[SteveCoppin]

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?

[Paul M]

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

[arena]

thank you nice

[1quick1]

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?

[Paul M]

There is a 3.7 version in the 3.7 forum.

[1quick1]

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:

[Davey-UK]

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??

[Paul M]

You can join them with a simple dos copy command.

As for the mod itself, read the notes in the config file for the various options.

[justchil]

Finally! Success!

I'm running a Plesk server and tried a few times to get this script running... turning safe_mode off for my domain worked. *Installed*

[dmeister]

I have basic computer skills. I had a person install this for me.

I am running this on 3.6.8. My webhost moved me to a different platform. Now when the auto back up runs it turns off my forums. If you are logeed on you get a banner at the top that says " Alert- forums have been shut off" If you are not logged on you get a full message stating that the forums are closed while the data base is being backed up, and does not come back on it just locks itself out. I have to turn off the plugins and hook system and turn it back on to make it work or reset.

Any suggestions on how to fix this
Thanks

[Paul M]

Disable the option that turns the forum off.

[dmeister]

I did some looking, could you point me in the right direction on how to do that?

Thanks

[Paul M]

Its the SHUTDOWN option in the config file.

[AURFSCAN]

Installed and a big thanks.

Works well

[SVTCobraLTD]

Installed, ran a manual test and it ran perfect. Will check again tomorrow morning after it runs tonight. Thanks

[SVTCobraLTD]

I did a backup yesterday and it was 163MB and just did the one here and it came out to 113MB. Any reason that there is a big difference?

When I was doing the backup via phpmyadmin I was adding drop tables and all those features.

[Paul M]

I did a backup yesterday and it was 163MB and just did the one here and it came out to 113MB. Any reason that there is a big difference?

I cannot answer that as I have no access to your forums or backups.

[BadgerDog]

Hi Paul.... :)

I've been backing up using this mod religiously.... thanks for posting it ...

I'm not that familiar with SQL or vBulletin internaks, so I've been wondering what I'd do if I had a complete hard disk failure on my host server.

I back up nightly using this mod with the option set to a "single file". I then move it to my local machine periodically.

Does the "database" (single file), as I understand it, contain ALL of the traditional data files, plus of all of the vbulletin code (including mods)?

In other words, if I had to setup a new server, would I simply install my licensed version of 1.67pl1 and then somehow have a techie restore this single file, which puts ALL of my threads, posts and forum (including mods) back to exactly the way it was prior to a failure?

Thanks for any feedback....

Regards,
Badger

[Paul M]

If by mods you mean plugins then yes. Obviously it wont include any additional files or file edits that some mods use.

[BadgerDog]

If by mods you mean plugins then yes. Obviously it wont include any additional files or file edits that some mods use.

Yes, I meant "plugins" that are added by mods, but also I use mods that I have to edit various templates....

Do vBulletin templates and all of the AdminCP settings get backed up as part of this single file as well?

Thanks

Regards,
Badger

[Paul M]

Anything stored in the database, which they all are.

[DanaRVT]

I just tested this by running it manually and I got

The Backup was completed successfully.
Done

but when I go to the backups folder... there is nothing in there. What did I do wrong?

[DanaRVT]

Nevermind lol I found it now!

If I wanted to gzip this, what would I need to add to the config file to do that?

[Paul M]

Nothing, this cannot zip the files.

[Reinhart]

Installed.
Is there a "Best Mod Ever" button I can click?

[Paul M]

You can nominate it for MOTM, thats the closest I think.

[brasolino]

can i install it safely on 3.6.10 pl2?

[Paul M]

Yes.

[mkdevo]

hi paul. not sure if you can answer this or not:

my host recently upgraded to php version 5.2.6. ever since then, when the backup is complete, it does not turn the forums back on automatically. i have to manually turn the forums on myself every morning.

any idea of a fix for this?

[Paul M]

The only "fix" is not to use that function, you dont need to turn the forum off.

[princeedward]

The only "fix" is not to use that function, you dont need to turn the forum off.hi paul...it would be nice if you can you tell us exactly...which file to edit and set this function...and how to do it...coz' my site remain closed also after backup...

thanks and best regards...

:)

[Paul M]

Its a setting in the config file.

[princeedward]

Its a setting in the config file.ahhh...OK! thanks...;)

[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.
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! :D


Also wanted to THANK Sparky5693 for his info about how to create an automatic rolling 7-day backup via this MOD. Works fine!
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.
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)
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...
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):
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! :)

[kronnos]

"Note: This modification is now discontinued" - I want to use this mod to backup my database using VB 3.6. I want to use the backup when I move to a new server and upgrade to 3.8. Will I have to install thsi mod on 3.8 to be able to use the restore function?

Edit: Ok installed and ready to try it. I cant find it anywhere in my admin panel to try to backup manually, how do i do it?

[adwade]

From my understanding, no you do not need this MOD installed to restore the files to your MySQL database.

In AdminCP, under Scheduled Tasks, Scheduled Task Manager, you should have an entry entitled Database Backup. You can do a Run Now and see if it works OK for you.

[SVTCobraLTD]

Nevermind I see there is a 3.8.x version available.

[djbaxter]

<a href="https://vborg.vbsupport.ru/showthread.php?t=201319" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=201319</a>