sql数据库导入失败，换了无数种方式

Question

导入数据库一直显示失败，显示找不到database

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : psychological_testing

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 28/02/2023 12:02:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for blanks
-- ----------------------------
DROP TABLE IF EXISTS `blanks`;
CREATE TABLE `blanks`  (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `answer_a` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `answer_b` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `answer_c` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `news_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `answer_d` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of blanks
-- ----------------------------
INSERT INTO `blanks` VALUES (4, '你情绪不好的程程度', '一般', '偶尔', '经常', '1', '天天', '2022-12-18 15:25:48', '2022-12-18 15:25:48');
INSERT INTO `blanks` VALUES (5, '你睡觉的时长', '12', '23', '15', '1', '9', '2022-12-18 15:26:07', '2022-12-18 15:26:07');
INSERT INTO `blanks` VALUES (6, '工作的时候会三心二意吗', '不会', '有时候', '经常', '1', '偶尔', '2022-12-18 16:17:33', '2022-12-18 16:17:33');

-- ----------------------------
-- Table structure for categories
-- ----------------------------
DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of categories
-- ----------------------------
INSERT INTO `categories` VALUES (8, 'creative', 'green', '能力测试', '2022-11-17 08:44:02', '2022-12-18 14:07:13');
INSERT INTO `categories` VALUES (9, 'emoji', 'orange', '智力测试', '2022-11-17 12:32:38', '2022-12-18 14:07:23');
INSERT INTO `categories` VALUES (10, 'discoverfill', 'blue', '情商测试', '2022-11-17 12:33:17', '2022-12-18 14:07:33');
INSERT INTO `categories` VALUES (11, 'github', 'yellow', '抗压测试', '2022-11-17 12:34:04', '2022-12-18 14:07:41');
INSERT INTO `categories` VALUES (12, 'evaluate', 'orange', '桃花运测试', '2022-12-18 16:16:20', '2022-12-18 16:16:20');

-- ----------------------------
-- Table structure for collections
-- ----------------------------
DROP TABLE IF EXISTS `collections`;
CREATE TABLE `collections`  (
  `id` int(29) NOT NULL AUTO_INCREMENT,
  `members_id` int(20) DEFAULT NULL,
  `news_id` int(20) DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- Records of collections
-- ----------------------------
INSERT INTO `collections` VALUES (3, 5, 1, '2022-11-17 12:02:39', '2022-11-17 12:02:39');
INSERT INTO `collections` VALUES (4, 5, 5, '2022-11-17 12:44:13', '2022-11-17 12:44:13');
INSERT INTO `collections` VALUES (5, 5, 4, '2022-12-18 14:26:30', '2022-12-18 14:26:30');

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` int(29) NOT NULL AUTO_INCREMENT,
  `members_id` int(20) DEFAULT NULL,
  `news_id` int(20) DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (6, 5, 1, '2022-12-18 16:23:46', '2022-12-18 16:23:46', '很准，专家把控');
INSERT INTO `comments` VALUES (5, 5, 1, '2022-12-18 16:02:44', '2022-12-18 16:02:44', 'xxxxx');

-- ----------------------------
-- Table structure for configs
-- ----------------------------
DROP TABLE IF EXISTS `configs`;
CREATE TABLE `configs`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for members
-- ----------------------------
DROP TABLE IF EXISTS `members`;
CREATE TABLE `members`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nickname` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `real_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone_number` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(4) NOT NULL DEFAULT 1,
  `pic` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `openid` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of members
-- ----------------------------
INSERT INTO `members` VALUES (3, '浮生.若梦', '1111', '1888377232', 0, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJvMYQGvVhaCudFzicRZEA6xE3zT1YwTuMlMlX865iaycQOFkunltNI3Hkq4Z46ydTaBUPxwxXGbGjA/132', 'ohysJ5aLHTXY5k8eh3uBYKCays_c', '2021-11-22 12:24:17', '2021-11-22 15:27:47');
INSERT INTO `members` VALUES (4, '浮生.若梦', '平平', '23232', 0, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTJCPRsBxC57V8iaKeEB7iadd9w9YRsicJibdtTU8MhiaMD93HLOw8HYHjib15LzEePhly26gAVmJGxyibWaQ/132', 'oiYn95WhbvygJSL7fCLVMQIMxbXY', '2022-01-07 07:51:25', '2022-01-07 09:26:59');
INSERT INTO `members` VALUES (5, '浮生.若梦', '', '', 0, 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 'ou2GFwGJNlE6k9ud12yhf_oJIh6A', '2022-11-09 02:15:41', '2022-11-09 02:15:41');

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `title` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `categories_id` int(20) DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `collection_count` int(255) DEFAULT 0,
  `view_count` int(255) DEFAULT 0,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num` int(20) DEFAULT 0,
  `test_count` int(20) DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, '你适合什么样的工作测试', '/images/tlPfORYs2IOMVfRV.webp', 8, '<p><span>当嘴里长溃疡时，可以去药店买个维生素C贴在溃疡处，维生素C贴融化后，溃疡也就基本治好了。</span></p>', 1, 45, '2021-01-15 13:45:19', '2022-12-18 16:23:51', '5min', 1, 12);
INSERT INTO `news` VALUES (5, '当大脑感到疲倦时，可以吃一个苹果，', '/images/HAOMZRzSg7BSLx1t.webp', 10, '<p><span>当大脑感到疲倦时，可以吃一个苹果，因为苹果中含有大量的矿物质硼，能够让疲倦的大脑迅速恢复清醒，这比喝咖啡有效果多了，且更健康！</span></p><p>当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，当大脑感到疲倦时，可以吃一个苹果，</p>', 1, 20, '2022-11-17 12:43:37', '2022-12-18 16:20:18', NULL, NULL, NULL);
INSERT INTO `news` VALUES (4, '当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。', '/images/VL41m6tIOhGb1rel.webp', 8, '<p><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span><span>当皮肤受到小面积损伤或烧烫伤后，可以在伤处抹上少许牙膏，可止血止痛。</span></p>', 0, 5, '2022-09-29 12:08:13', '2022-12-18 16:20:22', NULL, NULL, NULL);

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets`  (
  `email` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  INDEX `password_resets_email_index`(`email`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for posts
-- ----------------------------
DROP TABLE IF EXISTS `posts`;
CREATE TABLE `posts`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `members_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatarUrl` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `members_id` int(11) NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `images` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `comment_count` int(11) NOT NULL DEFAULT 0,
  `zan_count` int(11) NOT NULL DEFAULT 0,
  `look_count` int(11) NOT NULL DEFAULT 0,
  `share_count` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of posts
-- ----------------------------
INSERT INTO `posts` VALUES (3, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, 'sdsds', '[\"\\/images\\/6ZaibFXA5VHGRZv4.webp\"]', 0, 1, 1, 3, 0, '2022-10-08 06:33:17', '2022-10-08 06:45:56');
INSERT INTO `posts` VALUES (4, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, 'xxxx', '[]', 3, 1, 1, 0, 0, '2022-10-08 06:36:20', '2022-10-08 09:18:48');
INSERT INTO `posts` VALUES (5, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, 'xxcc', '[]', 4, 0, 1, 0, 0, '2022-10-08 06:36:26', '2022-10-08 09:21:28');
INSERT INTO `posts` VALUES (6, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '我家的小孩老师写字乱动，咋办呀', '[\"\\/images\\/k1qtovPU8YcFOFg4.jpg\"]', 0, 0, 0, 0, 0, '2022-10-08 09:28:33', '2022-10-08 09:28:33');
INSERT INTO `posts` VALUES (7, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '这个平台很好，我找到学习的乐趣了', '[\"\\/images\\/x9EdLDQ4C97lMYfm.jpg\"]', 0, 1, 2, 5, 0, '2022-10-08 09:29:35', '2022-10-08 09:33:26');
INSERT INTO `posts` VALUES (8, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '哈哈，请大家来围观', '[]', 7, 1, 1, 0, 0, '2022-10-08 09:29:58', '2022-10-08 09:30:27');
INSERT INTO `posts` VALUES (9, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '可以哦', '[]', 8, 0, 0, 0, 0, '2022-10-08 09:30:27', '2022-10-08 09:30:27');
INSERT INTO `posts` VALUES (10, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '这个平台很好呢', '[\"\\/images\\/XAf26DgG1Tll0FNC.jpg\"]', 0, 1, 1, 3, 0, '2022-10-09 15:20:58', '2022-11-04 02:35:27');
INSERT INTO `posts` VALUES (11, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 3, '我也觉得', '[]', 10, 0, 0, 0, 0, '2022-10-09 15:21:43', '2022-10-09 15:21:43');
INSERT INTO `posts` VALUES (12, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 5, 'xxxx', '[\"\\/images\\/Qxsiy6tMxtKWqjnp.jpg\"]', 0, 0, 0, 1, 0, '2022-12-18 11:57:26', '2022-12-18 11:58:51');
INSERT INTO `posts` VALUES (13, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 5, '有没有和我一样睡不着会胡思乱想的', '[\"\\/images\\/tiKMIIG50GeMJrpj.jpg\"]', 0, 1, 1, 1, 1, '2022-12-18 16:19:15', '2022-12-18 16:19:53');
INSERT INTO `posts` VALUES (14, '浮生.若梦', 'https://thirdwx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTLmtjiaJlQy9EichjuIS10Xt7czLEFfiaqlKicJF6XzFL3icIj5vXPJGicibMlkwQ56wF9hYfhfBoHtSXOMw/132', 5, '大家好', '[]', 13, 0, 0, 0, 0, '2022-12-18 16:19:41', '2022-12-18 16:19:41');

-- ----------------------------
-- Table structure for records
-- ----------------------------
DROP TABLE IF EXISTS `records`;
CREATE TABLE `records`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `members_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `news_id` int(20) DEFAULT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of records
-- ----------------------------
INSERT INTO `records` VALUES (12, '5', 5, '2022-11-17 12:44:10', '2022-11-17 12:44:10');
INSERT INTO `records` VALUES (11, '5', 1, '2022-11-17 12:13:46', '2022-11-17 12:13:46');
INSERT INTO `records` VALUES (13, '5', 4, '2022-12-18 12:01:26', '2022-12-18 12:01:26');
INSERT INTO `records` VALUES (14, NULL, 1, '2022-12-18 15:58:30', '2022-12-18 15:58:30');

-- ----------------------------
-- Table structure for user_blanks
-- ----------------------------
DROP TABLE IF EXISTS `user_blanks`;
CREATE TABLE `user_blanks`  (
  `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `users_id` int(20) NOT NULL,
  `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `select` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `news_id` int(20) DEFAULT NULL,
  `blanks_id` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_blanks
-- ----------------------------
INSERT INTO `user_blanks` VALUES ('2022-12-18 15:19:25', 5, 3, '不好', '浮生.若梦', '2022-12-18 15:19:25', 1, 3);
INSERT INTO `user_blanks` VALUES ('2022-12-18 15:26:17', 5, 4, '12', '浮生.若梦', '2022-12-18 15:26:17', 1, 5);
INSERT INTO `user_blanks` VALUES ('2022-12-18 15:26:19', 5, 5, '偶尔', '浮生.若梦', '2022-12-18 15:26:19', 1, 4);
INSERT INTO `user_blanks` VALUES ('2022-12-18 16:20:40', 5, 6, '经常', '浮生.若梦', '2022-12-18 16:20:40', 1, 6);

-- ----------------------------
-- Table structure for user_news
-- ----------------------------
DROP TABLE IF EXISTS `user_news`;
CREATE TABLE `user_news`  (
  `updated_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `users_id` int(20) NOT NULL,
  `id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  `news_id` int(20) DEFAULT NULL,
  `result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_news
-- ----------------------------
INSERT INTO `user_news` VALUES ('2022-12-18 16:23:22', 5, 2, '浮生.若梦', '2022-12-19 00:23:22', 1, '你的情况很好，适合找一份悠闲的工作');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp(0) DEFAULT NULL,
  `password` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `score` int(20) DEFAULT 0,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '[e-mail]', NULL, '$2y$10$bIjRv0oJ1CujGccaDYaw3exrnu/wuXg5A0lPxGpCAYOfZHyNCjXtS', NULL, NULL, '2021-01-15 13:44:42', '2022-09-29 12:09:10');
INSERT INTO `users` VALUES (2, 'admin1', '[e-mail]', NULL, '$2y$10$BWtLA7GBvIJjWGpVbecMcectNDoFWcIuFw.q9ryt5cgXg8oBoEWmC', NULL, NULL, '2021-01-16 15:24:12', '2021-01-16 15:24:12');

SET FOREIGN_KEY_CHECKS = 1;

Answer 1

以下内容由CHATGPT及阿里嘎多学长共同生成、有用望采纳：

---

首先，遇到数据库导入失败的问题确实会让人感到沮丧，但别担心，我们一起来逐步排查可能的原因，并尝试解决它。

1. 检查数据库服务是否运行： 确保你的MySQL服务正在运行。如果服务没有运行，你需要先启动它。

2. 检查数据库用户权限： 确保你用来导入数据库的用户具有足够的权限。通常，需要有创建数据库和写入数据的权限。

3. 检查数据库名称： 在导入SQL文件之前，确保你已经创建了目标数据库，并且数据库名称与SQL文件中指定的名称一致。

4. 检查SQL文件格式： SQL文件应该是正确的格式，没有语法错误。从你提供的文件内容来看，它看起来是标准的SQL语句。

5. 使用合适的工具： 如果你使用的是Navicat，确保你选择了正确的目标数据库服务器类型和版本。同时，检查文件编码是否与目标数据库兼容。

6. 检查导入过程中的错误信息： 错误提示“找不到database”可能意味着Navicat尝试连接到一个不存在的数据库。请检查你在Navicat中设置的目标数据库名称是否正确。

7. 手动执行SQL文件： 如果Navicat无法导入，你可以尝试使用命令行工具或其他数据库管理工具来手动执行SQL文件。

8. 检查SQL文件的字符集设置： 确保SQL文件中的字符集设置与你的数据库设置相匹配。例如，如果你的数据库使用的是utf8mb4，SQL文件中也应该指定相同的字符集。

9. 检查是否有特殊字符或注释： SQL文件中的特殊字符或注释可能导致导入失败。检查文件中是否有不兼容的字符或格式错误。

10. 检查文件大小和复杂性： 如果SQL文件非常大或包含复杂的数据结构，导入过程可能会失败。尝试分批导入或简化数据结构。

如果以上步骤都无法解决问题，你可以尝试以下操作：

• 联系技术支持： 如果你使用的是第三方工具，比如Navicat，可以尝试联系他们的技术支持寻求帮助。
• 查看日志文件： 检查MySQL的错误日志文件，可能会有更详细的错误信息。
• 搜索社区论坛： 有时候，其他用户可能遇到过类似的问题，并在社区论坛中分享了解决方案。

希望这些建议能帮助你解决问题。如果需要进一步的帮助，请随时告诉我。记住，每个问题都有解决的办法，耐心和细致是关键。