MyBB Community Forums

Hi,

When I try to restores a DB backup made with the MyBB Security Backups.

The phpMyAdmin says:

Quote:consulta SQL:

-- MyBB Database Backup
-- Generated: 11th December 2009 at 03:23
-- -------------------------------------
CREATE TABLE PREFIX_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 ha dicho:
#1050 - Table 'PREFIX_adminlog' already exists

Ideas?

Says what it says, you're trying to import a backup that already has MyBB tables in it, and it can't insert it again. You'll need to drop the current tables and then import it, but make sure you don't need the code in the tables to be dropped.

Now it says:

ERROR 1062 (23000) at line 2168: Duplicate entry '0-4-238' for key 'active'

Can you post here the 5 lines above and below 2168?

But first try to delete all the tables from the db and try to restore the backup once again.