XF 1.4 Xenforo SQL Tables

[KevinEssence]

So the SQL tables screwed up..and we were getting an error, when re-directed we were to basically delete the xenforo SQL database and recreate it but we don't know how to recreate it. When we restart httpd and SQL, the xenforo table is still empty. Any assistance would be great as we are not sure where to go from here.

 

[borbole]

So the SQL tables screwed up..and we were getting an error, when re-directed we were to basically delete the xenforo SQL database and recreate it but we don't know how to recreate it. When we restart httpd and SQL, the xenforo table is still empty. Any assistance would be great as we are not sure where to go from here.

If you deleted the db then the only way to get it back is to restore your most recent backup.

P.s. Just out of curiosity, how exactly were were your sql tables screwed up? What happened?

 

[KevinEssence]

1. http://gyazo.com/2ea787f08d7fda2d74d8706f2c2391c6
2. http://gyazo.com/dbd4d2b9e22d4552b712d0155fb42e25
3. http://gyazo.com/2ab7fe32a0bc5635bd67e7267dd6c032

then it told me to delete files and reload them..erm we only have a localhost.sql backup, how do I make it so it only uses the xenforo part?

 

[borbole]

1. http://gyazo.com/2ea787f08d7fda2d74d8706f2c2391c6
2. http://gyazo.com/dbd4d2b9e22d4552b712d0155fb42e25
3. http://gyazo.com/2ab7fe32a0bc5635bd67e7267dd6c032

then it told me to delete files and reload them..erm we only have a localhost.sql backup, how do I make it so it only uses the xenforo part?

Can you check whether you have InnoDB support enabled?

Take the xenforo tables from the backup file, usually they are prefaced with the xf_ prefix. Also you might want to take the tables added by the mods as well.

 

[KevinEssence]

Solved this not too long ago, the stress is over. Moral of story, take more backups haha..took me forever to edit my local.sql backup thing cause I usually just dump one big one

 

[borbole]

Solved this not too long ago, the stress is over. Moral of story, take more backups haha..took me forever to edit my local.sql backup thing cause I usually just dump one big one

Glad to see that you got it solved. Indeed, making frequent backups would be a good thing. Especially before you make any changes to your forum.

 

[KevinEssence]

Glad to see that you got it solved. Indeed, making frequent backups would be a good thing. Especially before you make any changes to your forum.

Cheers and thank you.