[Forum] SQL Statement for locking/closing forum?

[Gator777]

I am using MySQLDumper to backup my site, but I want to lock the board, have the backup run, and then unlock it via an SQL Statement.

So my question is, what SQL Statement should I enter to accomplish these tasks?

Close forum

Open forum

[Paul M]

Closing the forum is not quite as simple as running a simple sql statement.

Is there a specific reason you want to close it while you run the backup ?

[Gator777]

Closing the forum is not quite as simple as running a simple sql statement.

Is there a specific reason you want to close it while you run the backup ?

Yes Paul, MySQLDumper is not completing the dump after the cronjob initiates the dump, sometimes it nearly completes but just stops for some reason. Oddly enough, the same perl script works fine when initiated and using the UI (MySQLDumper).

[Paul M]

If it doesnt take very long, you could issue a general read lock on all the tables - that would prevent any updates while the backup runs.

However, this has a downside - it will not close the forums, but rather it will lock them up (and eventually cause you to run out of mysql connections).

[Gator777]

Roger that ...thanks for your response. I think I will keep experimenting and try to find out what is causing my backup to stop dumping. Sometimes it works and sometimes it doesn't.