MyBB Community Forums

I had tried everything on my own pc first and got everything all set up with mybb + mysql and then I moved it all over to my server (which is another desktop in my house, not a hosting)

mybb all works fine on my first pc but the server pc i get an error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'mybb.mybb_datacache' doesn't exist
Query:
SELECT title,cache FROM mybb_datacache
Please contact the MyBB Group for support.

when i tried to go to forums

i renamed the mysql database the same as the original on my pc.

IS there something specific that you must do when switching servers?

Did you restore the database from your computer to your server?

(2012-10-05, 08:08 AM)Nathan Malcolm Wrote: [ -> ]Did you restore the database from your computer to your server?

I am not sure what you mean by restore. I secure copied everything over from the one to the sever

actually i just thought of something. my name of the directory is not /var/www/mybb but is /var/www/forums
Does this mean this error is looking in the wrong directory?

Table 'mybb.mybb_datacache' doesn't exist

how would i change it to look in forums.mybb in that case?

Quote:1) Import the backup into any extra (temporary) db
2) export only the datacache table
3) Import into your real forum

Could you explain this in a bit more detail. I don't really understand it.

how do i import it?
I have already copied the /var/www/mybb directory over to the new server.
how do i export the database table from it?

You need to export the database from your local computer (via phpmyadmin for example) and import it to the database on your server.

I was unsuccessful at my attempts. I just started so i completely redid the forums.

thanks anyways