MyBB Community Forums

I moved the forum to new host but it shows this error while accessing admin page -
SQL Error:
1146 - Table 'techma_techmafiasru544.mybb_users' doesn't exist
Query:
SELECT uid,username,password,salt,loginkey,remember,coppauser,usergroup FROM mybb_users WHERE username='admin' LIMIT 1


And while accessing main forum following error is showed-
SQL Error:
1146 - Table 'techma_techmafiasru544.mybb_sessions' doesn't exist
Query:
DELETE FROM mybb_sessions WHERE ip='67.222.144.44'

Make sure your database details in ./inc/config.php are right, and check that the tables to actually exist in your database.

The database details are correct in config.php file and I imported db backup from existing site but it don't have mybb_users table.

Then it looks like your backup was incomplete, are you able to make another backup??

If you still have the backup from your old host, extract from there the missing tables and import it at the db of the new host.

I used a new db backup & it solved the problem.