XF 1.5 Xenforo.xf_user table has dropped how can I re create it

Hello, Earlier today our MySQL crashed for some reason and we somehow lost the Xenforo.xf_user Is there a way to recreate the table?

Server Error
Mysqli prepare error: Table 'Xenforo.xf_user' doesn't exist
  1. Zend_Db_Statement_Mysqli->_prepare() in Zend/Db/Statement.php at line 115
  2. Zend_Db_Statement->__construct() in Zend/Db/Adapter/Mysqli.php at line 381
  3. Zend_Db_Adapter_Mysqli->prepare() in Zend/Db/Adapter/Abstract.php at line 478
  4. Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 753
  5. Zend_Db_Adapter_Abstract->fetchRow() in XenForo/Model/User.php at line 446
  6. XenForo_Model_User->getUserById() in XenForo/Model/User.php at line 958
  7. XenForo_Model_User->getVisitingUserById() in XenForo/Visitor.php at line 415
  8. XenForo_Visitor::setup() in XenForo/Session.php at line 274
  9. XenForo_Session::startPublicSession() in XenForo/Controller.php at line 293
  10. XenForo_Controller->_setupSession() in XenForo/Controller.php at line 306
  11. XenForo_Controller->preDispatch() in XenForo/FrontController.php at line 368
  12. XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 152
  13. XenForo_FrontController->run() in /var/www/forums/public_html/index.php at line 13
 
Really hope you have backups.

This could imply you have forced all the tables to MyISAM which isn't crash safe and can cause total data loss of a table if MySQL crashes wrong.
 
You can recreate it, but all your users are lost, which in turn is going through mess up at a minimum the following tables:

xf_user_authenticate
xf_user_group_relation
xf_user_option
xf_user_privacy
xf_user_profile
 
Do you at least have email addresses of users, let them know what happened and ask them nicely to sign up again.

Isn't this how we all learn about backups?
Do you at least have email addresses of users, let them know what happened and ask them nicely to sign up again.

Isn't this how we all learn about backups?
Its okay our users are also in our Discord :)
 
Top Bottom