[How To?] Recovery backup!

[Roberth]

I have a database from 2015 called name_forum.sql. How do I restore it? I tried by installing the latest version of MyBB and uploaded the database through phpMyAdmin. The users show up in the database, but there’s no change on the forum. I’ve checked the link, cookies, and all settings, and everything seems correct. However, the users still don’t appear on the forum.

I also installed the 2015 version 1.8.6, but I’m getting an error.

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups text NOT NULL, type char(1) NOT NULL default '', postoptions text NOT N' at line 6
Query:
CREATE TABLE mybbtest_modtools ( tid smallint unsigned NOT NULL auto_increment, name varchar(200) NOT NULL, description text NOT NULL, forums text NOT NULL, groups text NOT NULL, type char(1) NOT NULL default '', postoptions text NOT NULL, threadoptions text NOT NULL, PRIMARY KEY (tid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

I tried to fix the error with:

CREATE TABLE mybbtest_modtools (
    tid smallint unsigned NOT NULL auto_increment,
    name varchar(200) NOT NULL,
    description text NOT NULL,
    forums text NOT NULL,
    `groups` text NOT NULL,
    type char(1) NOT NULL default '',
    postoptions text NOT NULL,
    threadoptions text NOT NULL,
    PRIMARY KEY (tid)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

How can I restore the old database?

[bv64]

are you sure you have linked to the correct database in inc/config.php?

recovering is equal to move a board: https://docs.mybb.com/1.8/faq/moving-to-a-new-web-host/

you have already correctly recognized that you have to install the MyBB version corresponding to your database; it won't work with the current one. The database and MyBB must therefore be on the same version

Actually, you need a database backup and the appropriate FTP backup, otherwise you won't have any file attachments, avatars and much more from the old board

[Roberth]

At the moment it seems that I can no longer pass the error in this version.

[Devilshakerz]

Generally, the latest version of MyBB (files) can be used - it would be copied over the old files, overwriting existing source code.
The upgrade script should detect the version in the database and run the relevant upgrade scripts.

Does any other content from the backup show?