[How To?] Restoring Mybb Database w/PHPMyadmin

[crazy4cs]

This user has been denied support.

I don't get, if you just moved them to new place, they won't be auto activated, you'd have to activate it or if you are at same place (directory), you might have deactivated them before you updated database.

[FooFighter]

Ok, thanks buddy.

[hddt]

Hi all,

I use Restoring a backup with phpMyAdmin method but after I click GO, error appear:

"Error
SQL query:

-- MyBB Database Backup
-- Generated: 06th December 2011 at 13: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:

#1050 - Table 'mybb_adminlog' already exists "

How can I restore databases?

Thank you!

[ranjani]

^ drop all tables in that database and import backup
OR create a new database & import the backup AND use its details in config.php file

[hddt]

^ drop all tables in that database and import backup
OR create a new database & import the backup AND use its details in config.php file

Thank you very much, I did it !

[pavemen]

please beware though that for large databases, this does not always work. often the file it too large for upload or too large to fully process and PHP times out. In that case, you will need to use SSH and MySQL command line to import the file (after creating the DB, user and perms as stated above)

[Projec13]

I am doing a restore to my forums, The backup was only made 1hr 1/2 ago, so its quite fresh. I followed your steps, created a new database, and uploaded. And I'm still getting the exact same error as guy above.



SQL query:

-- MyBB Database Backup
-- Generated: 29th February 2012 at 23:05
-- -------------------------------------
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
#2006 - MySQL server has gone away

[FooFighter]

So I had to restore another database and my forum looks like it did after I made the backup in which it should like the same as the backup I took.

I did this;

created database
created user/permissions
assigned user to the database
went to inc/config and edited the bold areas

$config['database']['type'] = 'mysqli';
$config['database']['database'] = 'mybb';
$config['database']['table_prefix'] = 'mybb_';

$config['database']['hostname'] = 'localhost';
$config['database']['username'] = '_______';
$config['database']['password'] = '_______';


And nothing

I even tried importing the .gz and the .zip with two different databases/users/permissions, etc... and still nothing.

Cleared my cache "ctrl + f5" and nothing
Restarted browser and nothing



Did I miss something.

The only thing different I did this time was kept board online and plugins remained activated.

-------------------------------------------------

You know whats weird was...

I made the backup first, then
after the backup I made changes to my template and theme and also renamed a forum category title
then I restored the backup
the forum category is back how it was prior to the backup however my template/theme changes I made afterward are still there?????

The changes I made to the template and theme were from this thread http://community.mybb.com/thread-116926.html
And I wanted to restore my backup since I couldn't get my template or theme fixed.

[eshagh]

hello friends.

for restore mybb database backup
1- i delete all table from my database in myphpadmin
2- import backup successfully

but now my forum have error
SQL Error: 1146 - Table 'zeytun_mybb.mybb_users' doesn't exist

please help me
www.zeytun.ir
thanks.