MyBB Community Forums

Hi,

I backed up all data using the db backup utility and downloaded the sql file. I am running lampp on linux and used phpmyadmin to import the sql file and I am getting this error (used utf8 as the character set for the file)

phpmyadmin: Version is 3.2.0.1

These are running

Starting XAMPP for Linux 1.7.2...
XAMPP: Starting Apache with SSL (and PHP5)...
XAMPP: Starting MySQL...
XAMPP: Starting ProFTPD...
XAMPP for Linux started.

Quote:Error

SQL query:

-- MyBB Database Backup
-- Generated: 14th December 2009 at 18:16
-- -------------------------------------
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
#1046 - No database selected

Any help would be appreciated. Thanks

---

I did not solve this problem.

But used my host's phpmyadmin to export the database. I could then successfully import it to my local server setup. (use this new database: changed the database name in /inc/config.php)

Did you solve the problem now?

Fyi, the first error occurred cos you didn''t select a database in which to restore the backup.

There was an issue with the MyBB backup utility in 1.4.10 ([issue=580]). Please see the following topic if it applies to you:

http://community.mybboard.net/thread-61015.html

If it's saying there was no database you probably just didn't choose your database from the list on the left on the phpMyAdmin home page...