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

[ForestGreen99x]

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

 

[Xon]

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.

 

[ForestGreen99x]

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.

Just found out that one of developers did it by accident but we don't have any backup of it, how could I recreate it?

 

[Ozzy47]

What is your most recent backup?

 

[ForestGreen99x]

Don't think we have any backups containing the mysql just waiting for the other owner to reply to me.

 

[Ozzy47]

That’s not good.

 

[ForestGreen99x]

That’s not good.

Yep we don't have one is there a way to re generate a new one? Also what data would be lost?

 

[Ozzy47]

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

 

[ForestGreen99x]

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

How can I recreate it?

 

[Paul B]

Recreating the table won't help - there will be a lot of orphaned records.

 

[Ozzy47]

How can I recreate it?

Your database is pretty much screwed at this point. What was the size of the site, members, posts etc?

 

[ForestGreen99x]

Your database is pretty much screwed at this point. What was the size of the site, members, posts etc?

Luckily we just opened our forums a week ago so we just had about 100 users and about 90 or so posts

 

[Ozzy47]

Well at this point it may be better off starting the site from scratch.

 

[ForestGreen99x]

Yeah, Is there a way to import our theme and important posts and addons?

 

[RobParker]

Yeah, Is there a way to import our theme and important posts and addons?

How can you import posts? You don't have any users associated with those posts any more.

At this stage I'd be going mad at your "developers" and wouldn't trust them for future work.

 

[ForestGreen99x]

How can you import posts? You don't have any users associated with those posts any more.

At this stage I'd be going mad at your "developers" and wouldn't trust them for future work.

Yeah If I create the same user who created the specific posts that we want back with the same user ID can it be imported though?

 

[Mr Lucky]

Well at this point it may be better off starting the site from scratch.

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?

 

[Kevin]

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

Seeing as how the email address would be in the users table...

Isn't this how we all learn about backups?

No.

 

[ForestGreen99x]

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