M
M
Matvey Tomilov2018-06-28 16:13:41
PHP
Matvey Tomilov, 2018-06-28 16:13:41

How to load the MySQL database if it gives such an error?

Good time, they sent the database and when I try to load it in PHPmyadmin it gives an error

SQL запрос:


INSERT INTO `rssbd_redirect_links` (`id`, `old_url`, `new_url`, `referer`, `comment`, `hits`, `published`, `created_date`, `modified_date`, `header`) VALUES
(274071, 'http://resurs35.ru/egg_web/39114.dwmodf', '', 'http://resurs35.ru/egg_howc/39114.dwmodf', '', 1, 0, '2016-09-04 02:22:35', '0000-00-00 00:00:00', 301),
(274072, 'http://resurs35.ru/egb_web/11252.dwmodf', '', 'http://resurs35.ru/egb_howc/11252.dwmodf', '', 1, 0, '2016-09-04 02:22:40', '0000-00-00 00:00:00', 301),
(274073, 'http://resurs35.ru/ega_web/6240.dwmodf', '', 'http://resurs35.ru/ega_howc/6240.dwmodf', '', 1, 0, '2016-09-04 02:22:47', '0000-00-00 00:00:00', 301),
(274074, 'http://resurs35.ru/egp_web/38844.dwmodf', '', 'http://resurs35.ru/egp_howc/38844.dwmodf', '', 1, 0, '2016-09-04 02:22:59', '0000-00-00 00:00:00', 301),
(274075, 'http://resurs35.ru/ege_web/49041.dwmodf', '', 'http://resurs35.ru/ege_howc/49041.dwmodf', '', 1, 0, '2016-09-04 02:23:00', '0000-00-00 00:00:00', 301),
(274076, 'http://resurs35.ru/egp_we[...]
Ответ MySQL: Документация

#1146 - Таблица 'y92183pc_re.rssbd_redirect_links' не существует


How can such a problem be solved?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
R
Ruslan Fedoseev, 2018-06-28
@martin74ua

dump is incomplete. Or you are missing something.
First, a CREATE TABLE table is created, then INSERT INTO data is put into it

M
Max, 2018-06-28
@MaxDukov

you need to create a table first

O
Oleg Seledets, 2018-06-28
@oleja1ee7

CREATE DATABASE namedb;
USE namebd;
CREATE TABLE rssbd_redirect_links(//////); / in brackets column name, data type, separated by commas. for example pole1 CHAR(25)
and here is your request

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question