MyBB Community Forums

Full Version: Importing Tables from Old Database to new
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I've looked all over for information on this, or some concise guide to allow me to import the mybb_posts, mybb_threads, and mybb_users from our current forum into one I'm developing locally via WAMP for testing purposes.
I found this old thread http://community.mybb.com/thread-92832.html but when following the advice on that thread:

Quote:"Create your new forum, take the mybb_posts, mybb_threads, and mybb_users and export them from your old forum, then delete the mybb_posts, threads, and users table from your new forum and import the old one to replace it."

I get this error in PHPMyAdmin:
MySQL said: Documentation
#1054 - Unknown column 'failedlogin' in 'field list'


My problem with a straight out upgrade is we were compromised at one point in the past, and have had lingering hard to solve issues.
My goal is a full reinstall with only the tables I mentioned above.
I'd like to know what the best method for accomplishing this would be.
you have to remove 'failedlogin' column from the backup you are trying to import
ALTER TABLE `mybb_users` DROP COLUMN `failedlogin`

or you can add it to your current MyBB database
ALTER TABLE `mybb_users` ADD COLUMN `failedlogin` bigint(30) NOT NULL DEFAULT '0'
Thanks a million .m.! Big Grin You've been a lifesaver to me on a couple of occasions now, keep up the good work!
Got the forum back up today: http://kritterbox.com
Couldn't have done it without you.