MyBB Community Forums

Ok, I set up a test board on local host using EasyPHP, here's the problem, I want to bring in my whole database from my real forum, to make it the most realistic simulation possible. How do I do that?

Thanks,

I'm not sure if you can backup a database, but you can look around phpMyAdmin and see if you can find an option that does that.

I've already backed up the db, its getting it over to the test board that's the problem.

Well, I'd assume you can just run the queries via phpmyadmin

Tried running the mybb_users queries and got this:

Error

SQL-query:

INSERT INTO `mybb_users`
VALUES ( 2, 'MrMedic', 'ca3a0aa2cedbb41f9b022c2118f24848', 'DLx3MOw9', 'S864f2dUAoNfQcPGKtPyoyBsFYpsIGs3gqYLM5BnmpS6RDE6xu', '[email protected]', 909, './uploads/avatars/avatar_2.jpg', '100|97', 'upload', 4, '', 8, 'Master Admin', 1155190179, 1175384800, 1175384801, 1175350320, 'http://www.schoolforums.org', '0', 'MedicMan5587', '', '', '17-10-1991', '[img]http://mrmedic.freehostia.com/images/avatars-signatures/mrmedic/dynamic.php[/img]\r\n\r\n[size=x-small]Need me? Shoot me a[url=http://schoolforums.org/private.php?action=send&uid=2] PM[/url] or [[email protected]]e-mail[/email]![/size]', 'yes', 'no', 'no', 'no', 'yes', 'yes', 'no', 'no', 'linear', 'yes', 'yes', 'yes', 'yes', 0, 0, 0, '0', '0', '-4', 'no', '3,65,6', '', 0, 'no', 0, '0', '', '1**Inbox$%%$2**Sent Items$%%$3**Drafts$%%$4**Trash Can', '', 0, 10, '', '', 1037593, 1, 225, 0, 0, '0', 0, '1175299200', '', '', '', '', '', '', '' )

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

Any idea what that means?

It means you have a plugin installed that's not on your localhost

[offtopic]
what is that!! all the support team changin they usernames!???????
[/offtopic]

pepotiger Wrote:[offtopic]
what is that!! all the support team changin they usernames!???????
[/offtopic]

That's not all

You should make a copy of the forum files on your localhost as well as the database. Then when you get both up, change the board URL to http://locahost/...

ikitikiT Wrote:

pepotiger Wrote:[offtopic]
what is that!! all the support team changin they usernames!???????
[/offtopic]

That's not all

It's April Fools, duh. I wonder what else they did.