Announcement

Collapse
No announcement yet.

SQL Statement for locking/closing forum?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] SQL Statement for locking/closing forum?

    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

  • #2
    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 ?
    Baby, I was born this way

    Comment


    • #3
      Originally posted by Paul M View Post
      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).

      Comment


      • #4
        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).
        Baby, I was born this way

        Comment


        • #5
          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.

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X