CODEWITHSUNDEEP
mysqlphpmyadmin
Derrick
Derrick

Reputation: 29

error #1046 when importing database

when importing database, this is the error that occurs:

-- Database: `maha associates`
--

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

--
-- Table structure for table `wp_commentmeta`
--

CREATE TABLE `wp_commentmeta` (
  `meta_id` bigint(20) UNSIGNED NOT NULL,
  `comment_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `meta_key` varchar(255) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,
  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
MySQL said: Documentation

1046 - No database selected

how do i solve that??

Upvotes: 0

Views: 3476

Answers (2)

lookAheadAssertion
lookAheadAssertion

Reputation: 21

Wherever you did the export from, choose "Custom - display all possible options" Under "Format-specific options:" Under "Database system or older MySQL server to maximize output compatibility with:" Choose: MYSQL323

Upvotes: 0

MatSnow
MatSnow

Reputation: 7517

Put this at the beginning of your file

USE yourdatabasename;

This defines the target database for mysql.

Upvotes: 1

Related Questions