• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.4 Xenforo SQL Tables

#1
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

Well-known member
#2
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?
 

borbole

Well-known member
#4
  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.
 
#5
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

Well-known member
#6
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.