MyBB Community Forums

Created new /forum with new database.
Is it possible/how to replace the new database with an older backup database in order to get the old categories>forums>subforums into the new (and updated version) forum ?

Ps:
Answer from host...
Hello,
It is trying to create the table "mybb_adminlog" but it already exists.
For more info you would need to contact MyBB support.

> Thank you for the info.
> Am trying to create a new MyBB forum with updated MyBB version (thus
> Softaculous), and then, if possible, import a backup database (with previous
> categories>forums>subforums, list of registered users, etc) for put the info in
> the new forum.
> Dont know if possible with ecP or not.

>
> The answer I find on MyBB forums is...
> "Go into your new hosting control panel and find out how to get into phpmyadmin.
> Once
> you are in phpmyadmin click on your database name on the left. Once you click on
> the database
> you will have access to all of the database tables. Now look at thetop on the
> right for the tab that
> says "SQL". Now look down to where it has a browse button and says "Or Location
> of the textfile:".
> Click on the browse file to find the Database Backup you downloaded on your old
> forums.
> Then click the "GO" button, once its done it will have inserted all of the
> database a "
>
> The database file I am trying to import is in a Pkzip 'folder' called...
> backup_b52441e5b2aZA2MREbVvBeiDGa48mGh8KpNj5QyiEtKeCVnO34KguD9BFB2aI2kV.sql
> ...and the name of the file is...
> backup_b52441e5b2aZA2MREbVvBeiDGa48mGh8KpNj5QyiEtKeCVnO34KguD9BFB2aI2kV.sql
> Is that not something that can be imported at...
>
> ecP
> File to Import:
> File may be compressed (gzip, bzip2, zip) or uncompressed.
> A compressed file's name must end in .[format].[compression]. Example: .sql.zip
> Browse your computer:
>
> Tried 'Go' button, but get following error...
>
> Error
> SQL query:
> -- MyBB Database Backup
> -- Generated: 18th February 2013 at 23:21
> -- -------------------------------------
> CREATE TABLE mybb_adminlog (
> uid int( 10 ) unsigned NOT NULL default '0',
> ipaddress varchar( 50 ) NOT NULL default '',
> dateline bigint( 30 ) NOT NULL default '0',
> module varchar( 50 ) NOT NULL default '',
> action varchar( 50 ) NOT NULL default '',
> data text NOT NULL ,
> KEY module ( module , action )
> ) ENGINE = MYISAM DEFAULT CHARSET = utf8;
> MySQL said: Documentation
> #1050 - Table 'mybb_adminlog' already exists
>
> Any ideas on what the problem may be ?

If you're trying to install MyBB using softaculous then, you've to drop the existing tables before you import your own database, by opening phpMyAdmin in cPanel. Just select the tables and click on drop. That should do it.

You were right, I just didnt quite understand the 'drop' process !
After some browsing I did figure out how to 'drop', and now have 2 forum directories and 2 databases.
1 forum-A (the new updated MyBB) shows up fine.
The other forum-B (old forum for get info, categories/forums/posts, to copy/paste to new forum) does not display.
Get error message...

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'akmblogo_akmblog'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server

Do I need to change a database reference it the forum-B file/s, or what else may need to be done ?

(2013-04-28, 02:26 AM)Jimmy. Wrote: [ -> ]If you're trying to install MyBB using softaculous then, you've to drop the existing tables before you import your own database, by opening phpMyAdmin in cPanel. Just select the tables and click on drop. That should do it.

akm Wrote:MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1045 - Access denied for user 'akmblogo_akmblog'@'localhost' (using password: YES)
Query:
[READ] Unable to connect to MySQL server

Do I need to change a database reference it the forum-B file/s, or what else may need to be done ?

http://docs.mybb.com/inc-config.html

Use the above Document and Configure your inc/config.php with the appropriate details.