"./" means the 'current' directory.

i run the server. what kind of permissions do i need to set? what exactly does this error message mean?

The webserver user needs write permission to the folder (normally you would just set the permissions to 777) - also, you must make sure that no php open_basdir restrictions will prevent php from writing to the folder. The message means that apache/php did not have write permission to the backup folder you have specified, therefore it cannot create the backup file(s).

I have what seems to be an odd problem, maybe someone with coding knowledge would be able to explain it better.

When I run the script manually (run now) it works fine.. shuts the forum down, backs up the tables, turns the forum back on.

When it runs automatically it turns the forum off and I believe it stops at the post index table and does not progress and the forum stays off.

Why would it work fine with a manual start but not automatic? Does it execute in a different manner?

bump

There is no difference in how it runs.

will be installing this, it will come in hand to have a daily backup. You never know when you need a backup.

yes it is not turning the board back to online!!! be carefull just use manual backup.. thanks for the mod but it would be better if it could turn back to online.. also a gzip would be good to store whole db..

so any idea why it would hang when its run automatically and not when its run manually?

How about MySQL 5? Does it compatible with that?

Yes, you can use that for MySQL5 as well.

All it does is add the DISABLE KEYS command while the data is being loaded (and then ENABLE them afterwards).

Ok.. Paul.. I just installed it.. I'm using MuSQL v5.0.24-standard-log.. I didn't change any value for this "$backup['MYSQL4'] = 1; // Set to 1 if you are using MySQL4".. I mean keep it as it is.. Then run it from Schedule Task Manager without having any error.. Does that mean its working fine?

You won't know that until you restore a database using the output file.

how does it work ??
I installed but i dont know how to backup database ?

It 'll take the backup automatically using cron.

I have a few questions, first of

My database is 30mb, is there a way to keep get it smaller?
Also i would like to archive a few days of database backups and then have a cron script that will remove the old ones so i dont build up a few gig just in backups.

Also if i needed to restore one of these files, how would i do it?
Is there a way i can restore it from script /home/myname/forum_db_backup/
It would take a hour to download it from the server and iv never been able to restore it via php myadmin, (any file over 10mb) as it stops responding and looks up, probally due to timeouts etc.

Thats why id like the server side to restore to save me having to download and upload etc.

Anyone know how this can be done?/or make a script/cron for this hack

Thanks heaps :D

Thank you so much! Installed and just did a test run, works!

BRILLIANT !!!!

Works superbly on 3.6.4

Thanks Paul :)

Its taking around 7 mins to run so i've changed the forum off message to suit :)

It will be getting run at 3am so shouldnae be many on so letting my forums stay closed whilst it completes it :)

*clicks install*

When i test this mod on localhost(windows), it work successful, But when i publish this mod on my server(linux), it not work
I config like
and I chmod 777 to backups folder
I click run now Dbbackup in Scheduled Task Manager, display this error
But I browse backups folder , it create a folder like 2006-12-08 (?)
What this problem ? Can u support me ?

Tonygau, check the config backup path is correct, and also chmod 777 the folder.

Looks nice! Very nice!

Does it also work with the really big ones?

Define "really big".

2GB + Databases.
200.000 + Posts.

Well our forum has about 850,000 posts and backs up fine, but the database isn't 2GB. The largest I've personally used it on was 1.4GB, I see no reason why size would matter though.

Just wondering :-).

Because vBulletin advices to avoid the build-in backup option if you have a large database.

Thanks again Paul!

Paul, is there a way to purge the backed up databases automatically after a certain day? Like, purge backed up databases after 5 days?

Thanks Paul for a great hack for us Admins. :up:

Sorry no, there is no such option, you have to do it manually.

Hey Paul/all. Thanks for this update... I'm a recovering Win2k person and I'm trying to get a handle on MySQL via command line, I've used Navicat for most of my MySQL work so far... The backup seems to work flawlessly, can anyone point me to a good way to restore it on another server? I've got a test server and I've copied the folder with all the .sql files in it. I downloaded a copy of the MySQL Administrator but it only seems to work with a single file at a time? I assume there's an easier way via the command line? ::sigh:: Thanks in advance for any assistance anyone can provide... Or for pointing me in the right direction ;-).

Connect to mysql from a command line using the "mysql" command, then connect to the database using the "use" command, then import the file using the "source" command.

I think I've puzzled out most of the details, thanks for pointing me towards the relevant commands. The one thing I haven’t been able to get working yet is the use of a wildcard for the source command? In a windows environment (my testbed) I dropped a copy of the backup folder created by this mod at the root of c:\ I connected and logged into the mysql utility with my target database active.

Then I tried:
source c:\2006-12-19\%.sql
but that threw an error.

I tried:
source c:\2006-12-19\*.sql
just for the heck of it but that threw an error as expected too.

IS there a way to feed in multiple files? Doing it individually works but that’s a LOT of files to run though. O.o

I’m quite sure I’m missing something very basic here, but it’s the dead bone simple things that are the hardest to figure out as none of the references mention them ;-). I really appreciate the help… I’m TRYING to get a handle on the command line vs GUI as I need to move in that direction to effectively work in Linux (my production server) but I’m not quite there yet.

Amazing

Thanks

I don't think the source command will accept wildcards - join the files into one big one with the windows copy command.

Limited time = 3600 => what does mean 3600 ??

Thanks... I'm kind of surprised that there isn't wildcard functionality, you'd think it would make things a lot easier. ::shrug:: I did a quick

copy *.sql 2006-12-19.sql

And then

source c:\2006-12-19\2006-12-19.sql

And it seemed to restore fine. Thanks for the help... I thought it might be useful to post the specifics back in case any other non-linux fossils like myself come looking for an answer in the future ;-).

I assume there's a comparable command in linux to concatenate the files into a single .sql so that you can restore from a backup without going through (in the case of my particular DB) 182 source commands?

Adding a backup to single file option might be helpful, though I can see how having each table individually would be useful too...

Anyway, thx for the help!

3600 seconds (1 hour).

If there is I don't know what it is - I have to join them in windows.

::stunned shock::

How dreadfully ironic. In order to do a restore we have to ftp the files to a WINDOWS host to run a *command line* utility so we can put the file back up on the Linux host and run the restore? ::laughter::

I'd think the MySQL community would add wildcards just for that reason.

Sorry... I realize nobody else might find that amusing but I can't help it...

Thanks again Paul!

::wanders off chuckling::

worked fine

thank you

clicked;)

I get this error,
What do I do? Make a file for it to write too?

No, it means your web server does not have write permission to the folder you have chosen.

Nevermind! THANKS!!