Basically, my host canceled on me so I had to re-install MyBB on a new host, now when I try and restore the backup via PhpMyAdmin I get errors about uncreated databases, even though I've created them on my new host exactly the same names as before.
Any help?!
What exactly does it say?? Have you chosen a specific database to import this backup to??
I'm not sure, it says:
Error
SQL query:
-- MyBB Database Backup
-- Generated: 06th September 2010 at 10:55
-- -------------------------------------
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:
#1046 - No database selected
Yeah, you've not chosen a database. When you first get into phpMyAdmin you should see a list of databases on the left, click your one, then the Import tab.
I did that but this time a different error:
SQL query:
-- MyBB Database Backup
-- Generated: 06th September 2010 at 10:55
-- -------------------------------------
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
Can someone help via TeamViewer?
Just delete the tables that have been imported into your database and try it again.
I don't understand, remove my new MyBB installation and just use the backup via Phpmyadmin?
Ok it worked but my theme is screwed up?
Wherever did you get the idea that I said "remove mybb" ??
All I said was for you to go into the database you're trying to import your db backup to, delete the tables in it, then reimport the database backup file again.
I did that but now my theme is completely missing, it's all a mess?