One question, after I restore the database and go to the forum it still say " Forums is close ...." shouldn't it turn on automatically? Just to make sure that i'm not doing anything wrong

No, you will have to turn it on manually if it's closed (because you backed it up closed).

thanks Paul,

In the future will you include FTP option so it can upload the db to an external server for a second back up? This is a nice feature to have, hope to see it future version.

Thanks

I apologize for being a newb here, but is there a step by step of how/where to install this on my database and then how to turn it on so that it backs up all the information I need automatically?

which directory you guys backup to? I backup to the same server my forum resides but given that the backup folder is 777, other people will be able to read my database backup ?

Hey Paul, in our site the script halt on "Database Backup" and stays there.

In the FTP, the new date dir is created, but the site is not closed and a sql file is not generated.

3.6.4

Then you have a problem with your set-up.

PHP obviously ran out of memory. If you have access to php.ini then you can manually increase the allocated memory for PHP, but backups by nature will always be resource intensive.

Sorry for not replying sooner. Yes, of course you can use the code.

You can also create/edit the .htaccess file in your forum directory. Add the line:
If your host allows this you can boost the allowed memory.

I really wish I could use this mod... Is there any chance of a MysqlHotCopy version of this? Or is there already something out there that I'm not finding?

With over 3.5 million post table records and no slave DB server, using mysqldump really isn't an option (downtime would be way too long). :(

Mysqlhotcopy can do the backup in 3 minutes, but I wish I could find a mod like this to shut down / open the boards automatically...