· 7 years ago · Nov 14, 2018, 06:50 PM
1[Err] 1813 - Tablespace for table '`log`.`itemshop_log`' exists. Please DISCARD the tablespace before IMPORT.
2[Err] /*
3 Navicat Premium Data Transfer
4
5 Source Server : localhost_3306
6 Source Server Type : MySQL
7 Source Server Version : 50634
8 Source Host : localhost:3306
9 Source Schema : log
10
11 Target Server Type : MySQL
12 Target Server Version : 50634
13 File Encoding : 65001
14
15 Date: 27/08/2018 12:31:35
16*/
17
18SET NAMES utf8mb4;
19SET FOREIGN_KEY_CHECKS = 0;
20
21-- ----------------------------
22-- Table structure for itemshop_log
23-- ----------------------------
24DROP TABLE IF EXISTS `itemshop_log`;
25CREATE TABLE `itemshop_log` (
26 `item_vnum` int(12) NOT NULL,
27 `count` int(12) NOT NULL,
28 `id` int(12) NOT NULL,
29 `category` int(12) NOT NULL,
30 `account_id` int(12) NOT NULL,
31 `price` int(12) NOT NULL,
32 `channel` int(12) NOT NULL,
33 `date` datetime(0) NOT NULL
34) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Compact;
35
36SET FOREIGN_KEY_CHECKS = 1;
37[Msg] Finished - Unsuccessfully
38-------------------------------------------------