MyBB Community Forums

Full Version: Found, thought lost database! How to proceed?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
I thought that I had lost an old forum (system and multiple backups died at the same time but this was a forum with only me on it) but I just found a database backup of it!

It is not from too long ago and looking at the now recreated db .... I would guess that the version was 1.8.29 dated 30 October 2021.

I have none of the files, just the database.

It has 76 tables in the db.

I recall that it used the Roundo theme and that the version would be 1.04

What is the best way to proceed?

I have uploaded the db and using phpmyadmin ... all looks fine, but should I directly link it to one of the current test site I have (which is using 1.8.37 with BootBB as the theme) or download 1.8.29 and then upgrade to the current version?
Can you remember the superadmin account (UID: 1) ?

Just a blind fast startup:

Create 2 databases.
Restore your old database backup in database-1
Do a fresh MyBB installation in database-2

Open 'inc/config.php and change the database credentials to database-1 (you need to retrieve old table prefix and use it here, easy).
Delete database-2.
Thanks for the reply mate Smile

I know that I am UID: 1 and just looking I think I still have the password, so that should be fine (and at worst I know how to change the password in the db inc the salt).

I am concerned about the 76 tables instead of 75 and what changes to the database tables may have been made since 1.8.29?
It might be a custom table made by a plugin.
Can't tell unless you are posting your table list.

Anyway, you have an excess table, not lacking one. You are good to go I guess.
Strange .... all I get is a completely blank web page!
No errors from either the forum files or server .... just an utterly blank web page lol
Can you access admin CP? Then:
- Check and force apply Default theme to all.
- Check / Disable GZip compression of pages.
- Reconfirm correctness of .htaccess
(2024-02-23, 05:44 PM)effone Wrote: [ -> ]Can you access admin CP? Then:
- Check and force apply Default theme to all.
- Check / Disable GZip compression of pages.
- Reconfirm correctness of .htaccess

No I can't access ACP (just blank web page) mate lmao

I have just deleted all files (after full backups) and will now redo the base install of the current MyBB .... and then try to swap db once again lol

(after I have a quick smoke .... all good fun .... back soon)

So just made a new forum .... all good inc access to acp

Swapped the db in config .... back to totally blank web page but with no errors lol

Checking the "old" db .... all looks correct except 76 tables rather than 75??
Access database directly, open table mybb_settings > name "gzipoutput", check / set value to 0.
Set style value to 0 of your user entry in mybb_users table.
Done but no luck buddy .... no errors to work from .... I don't get it lol
If these don't work:

1. Try renaming inc\plugins folder to something else and try reloading forums.
2. Check recent entries of server error log, you may get some light there ...
Pages: 1 2