No announcement yet.

Query to run to rebuild search inded from CLI?

  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Query to run to rebuild search inded from CLI?

    I've been having issues getting the search database to fully and properly rebuild (5,000,000+ posts) without eventually timing out (I believe - I go to bed and wake up to a white screen and search results are incomplete at best). I'd like to be able to run the query via the mysql CLI so I can be assured that it's completing properly.

    So in short, what query do I need to throw in there and let run?


  • #2
    anyone? It's definitely not completing and I can't be around to watch it update 5,000,000 posts to figure out just where it is dying. It would be really nice to be able to run these from the CLI so my members can have a functioning search.


    • #3
      Sorry, I don't know the answer to this. You may want to put in a support ticket or post in the Server Configuration forum and they may be able to help out with a query for you.

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help


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