Not Solved Can't Restore backup?
#1
Not Solved
I'm upgrading from 1.8.6 to 1.8.24 with a clean installation.

Previously I backed up the database (selected everything) and used the default settings.

Now, when I try using phpmyadmin to import the sql.gz the following error message is presented;


Error

SQL query:

-- MyBB Database Backup
-- Generated: 11th February 2021 at 16:26
-- -------------------------------------


CREATE TABLE `mybb_adminlog` (
`uid` int(10) unsigned NOT NULL DEFAULT '0',
`ipaddress` varbinary(16) NOT NULL DEFAULT '',
`dateline` int(10) unsigned NOT NULL DEFAULT '0',
`module` varchar(50) NOT NULL DEFAULT '',
`action` varchar(50) NOT NULL DEFAULT '',
`data` text NOT NULL,
KEY `module` (`module`,`action`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


MySQL said: Documentation
#1050 - Table 'mybb_adminlog' already exists

How can I fix this?

Thanks
Reply


Messages In This Thread
Can't Restore backup? - by PDA1 - 2021-02-13, 01:17 PM
RE: Can't Restore backup? - by nixer55 - 2021-02-13, 02:30 PM
RE: Can't Restore backup? - by PDA1 - 2021-02-13, 02:34 PM
RE: Can't Restore backup? - by Matt - 2021-02-13, 06:28 PM
RE: Can't Restore backup? - by PDA1 - 2021-02-13, 09:28 PM
RE: Can't Restore backup? - by Matt - 2021-02-13, 10:05 PM
RE: Can't Restore backup? - by PDA1 - 2021-02-13, 10:09 PM
RE: Can't Restore backup? - by Matt - 2021-02-13, 10:34 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)