After removing about 2500 pages from a flashchat program that we no longer use, I have a somewhat downscaled size of file, about 33 megs.

Now, I am going to try and import this using a txt importer.

I just found out that this host does support SSH, so that might be an option in the very near future if this doesn't work.

Okay...I have 38 seperate categories (Tables I believe they are called) within the database now.

Rick, do I need to do an upgrade? What steps do I need to do to complete this move and get our forums back online?

I have am going to try and bring over the previous version of the includes/config.inc.php file and then fix it with the appropriate new server info.

I hope that this works. If it doesn't, any other ideas?

That should do it. The main thing you'll want to edit is the database info, and then any path information, like the FULL_PATH, SESSION_PATH and possibly directories listed for the avatar/attachment storage directories.

Once you get those updated you should be able to login and go to the control panel, and then you'll want to clear the cache to make sure everything updates properly.

Got it done. Now all I am getting is the following message:

UBB Message We encountered a problem. The reason reported was
Script: /home/content/70/5375670/html/forums/libs/user.inc.php
Line#: 467
SQL Error: Table 'ophaweb1.ubbt_USERS' doesn't exist
SQL Error #: 1146
Query: SELECT t2.USER_TOPIC_VIEW_TYPE, t2.USER_TOPICS_PER_PAGE, t2.USER_POSTS_PER_TOPIC, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF,t2.USER_GROUP_IMAGES,t2.USER_TIME_FORMAT FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 2 AND t1.USER_ID = t2.USER_ID

Please click back to return to the previous page.

I found Gizmo's article on how to get to the root of the problem. I am working on fixing this issue. I will keep you updated.

Is there anyway to just recreate this table? Would the Database, the forum or my users suffer any ill effects?

Hmm, that's an important, that's the primary user table and without it you won't have any users at all. Did you get any error messages when trying to restore the backup?

None. I looked through my database files and the very last table is ubbt_posts

Definitely missing some key tables then. It sounds like the backup from your current/old host wasn't complete. If you can't get a complete backup using phpmyadmin then you'll probably need to request that they do a full backup for you that you can download.

Perhaps you timed out while importing the POST table as well causing not all your post's to be imported. You may wish to check that too.