Error #1046 while importing a database

Question

Error
--
--Database: "wordpress"
--
-- --------------------------------------------------------
--
-- Table structure for table "wp_brizy_logs"
--
CREATE TABLE "wp_brizy_logs" (
  "id" bigint(20) NOT NULL,
  "type" text NOT NULL,
  "message" text NOT NULL,
  "context" text NOT NULL,
  "session_id" text NOT NULL,
  "date" datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
#1046 - No database selected

Here's my log, what may be the problem? I'm using XAMPP, but i've tried with MAMP too and the result was the same.

Simple - you're not connected to a database, maybe a server, but the database itself. For this, try adding your database name at the start, for example; `CREATE TABLE mydatabase.wp_brizy_logs ( ...` — Can O' Spam, Jun 26 '18 at 10:07
`#1046 - No database selected` seems pretty clear. (Create/)Select a database first. — JustBaron, Jun 26 '18 at 10:08
@SamSwift웃 If he/she is creating tables, most likely would be creating more objects or populating the tables. To avoid code complexity, `USE databaseName` is better. — Cleptus, Jun 26 '18 at 11:12

score 0 · Answer 1 · answered Nov 11 '19 at 05:30

0

You have to create an empty table first. Then upload your files into that empty table. You probably solved it by now but just putting this here in case someone else runs into the same problem.

answered Nov 11 '19 at 05:30

user8322222

489
3
14
28

Error #1046 while importing a database

1 Answers1