MyBB Community Forums

I receive the following error when I try to move my website (manually) to a new host. I can't get PHPMyAdmin to accept the SQL database that I've uploaded. It doesn't work, and I get the following.

MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table '********.mybb_datacache' doesn't exist
Query:
SELECT title,cache FROM mybb_datacache

How can I manually input the tables without taking up an inordinate amount of time? Or, how can I upload it so that it will "take", and work? My new host does not transfer from other hosts, sadly.

Do you have backup of your forum?
If you have, upload that backup. Or setup forum on localhost then import that database, after that export just that table and import it in your forum.

What happens when you try to import your database backup via phpmyadmin? It should be a fairly simple process.

I get a blank screen, and nothing happens otherwise.

How large is the backup file?

That's extremely odd. How are you going about uploading it? You could try using a tool such as bigdump to see if it helps at all: http://www.ozerov.de/bigdump/

(2012-04-22, 08:16 PM)MattRogowski Wrote: [ -> ]How large is the backup file?

3.1 MB. I've also tried splitting it into two files, but that doesn't work, either. Am I missing a limit or something?

(2012-04-22, 08:16 PM)euantor Wrote: [ -> ]That's extremely odd. How are you going about uploading it? You could try using a tool such as bigdump to see if it helps at all: http://www.ozerov.de/bigdump/

Thanks, I'll look into it.

3.1 mb is not a big database. You can upload it normally. Try what i sayed above to get just one table from whole database if you can't upload all tables.