Форум сервиса вфосе.ру

У меня MySQL отвечает когда я захожу в структуру таблицы "torrents":
#145 - Table '.\vgk\torrents' is marked as crashed and should be repaired
как исправить? :unknown:

vgkseul26 писал(а):У меня MySQL отвечает когда я захожу в структуру таблицы "torrents":
#145 - Table '.\vgk\torrents' is marked as crashed and should be repaired
как исправить?

translate писал(а):отмечен, поскольку потерпел крах и нужно быть восстановимым

А как его восстановить?

vgkseul26 писал(а):А как его восстановить?

Код: Выделить всё • Развернуть

REPAIR TABLE 'torrents'

у меня ошибка когда делаю запрос на бд:
#1062 - Duplicate entry '1' for key 1
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in T:\home\localhost\admin\mysql\phpmyadmin\libraries\common.lib.php on line 685
подскажите как исправить плиз.

Какой запрос? К какой БД?

Я хочу восстановить торренты по резервной копии, но я поставил другой двиг.
Делаю запрос:

INSERT INTO `readtorrents` VALUES
(161, 1, 32),
(160, 5, 31),
(159, 1, 31),
(158, 5, 30),
(157, 5, 29),
(156, 1, 30),
(7, 5, 4),
(8, 5, 5),
(9, 5, 6),
(10, 1, 6),
(11, 1, 5),
(12, 1, 4),
(13, 1, 7),
(14, 5, 7),
(15, 1,

,
(16, 5,

,
(155, 1, 29),
(18, 7, 4),
(19, 7, 5),
(20, 7, 6),
(21, 8,

,
(22, 9, 7),
(23, 1, 9),
(24, 5, 9),
(25, 11, 9),
(26, 11, 7),
(165, 3, 30),
(167, 5, 33),
(168, 39, 7),
(30, 5, 10),
(164, 3, 31),
(32, 11, 5),
(33, 11, 10),
(34, 8, 11),
(35, 1, 11),
(163, 3, 32),
(166, 1, 33),
(38, 8, 12),
(39, 1, 12),
(40, 5, 11),
(41, 5, 12),
(42, 14, 10),
(43, 14, 4),
(44, 11, 12),
(45, 1, 10),
(46, 15, 11),
(47, 15, 12),
(48, 15, 7),
(49, 15, 4),
(55, 11, 16),
(54, 5, 15),
(53, 5, 14),
(56, 5, 16),
(57, 1, 16),
(58, 11, 14),
(59, 1, 14),
(60, 1, 15),
(61, 11, 17),
(62, 5, 17),
(63, 18, 17),
(64, 18, 10),
(65, 14, 6),
(66, 18,

,
(67, 1, 17),
(68, 18, 7),
(69, 7, 7),
(70, 11, 4),
(443, 94, 30),
(437, 94, 24),
(152, 37, 7),
(74, 14, 5),
(75, 14, 7),
(76, 14,

,
(77, 14, 9),
(78, 14, 11),
(79, 14, 12),
(80, 14, 14),
(81, 14, 15),
(82, 14, 16),
(83, 14, 17),
(84, 14, 18),
(85, 1, 18),
(86, 11, 19),
(87, 1, 20),
(88, 5, 18),
(89, 5, 19),
(90, 5, 20),
(91, 1, 19),
(92, 22, 6),
(447, 94, 35),
(449, 94, 37),
(95, 11, 21),
(96, 5, 21),
(450, 94, 38),
(444, 94, 31),
(99, 1, 21),
(451, 94, 39),
(445, 94, 32),
(102, 24, 12),
(103, 24, 10),
(104, 25, 12),
(105, 25, 22),
(106, 5, 22),
(151, 22, 23),
(108, 1, 22),
(109, 5, 23),
(110, 1, 23),
(441, 94, 28),
(112, 22,

,
(440, 94, 27),
(114, 5, 24),
(115, 25, 24),
(116, 25, 9),
(117, 7, 12),
(118, 31, 12),
(119, 31, 24),
(120, 1, 24),
(121, 32, 9),
(446, 94, 33),
(123, 16, 23),
(124, 16, 12),
(448, 94, 36),
(442, 94, 29),
(439, 94, 26),
(128, 5, 25),
(129, 34, 26),
(130, 1, 25),
(131, 1, 26),
(438, 94, 25),
(133, 18, 23),
(134, 9, 24),
(135, 18, 16),
(136, 35, 23),
(137, 26,

,
(138, 11, 20),
(139, 18, 21),
(140, 16, 4),
(141, 3, 27),
(142, 3, 28),
(143, 5, 27),
(144, 5, 28),
(145, 3, 7),
(146, 1, 27),
(147, 3, 20),
(148, 1, 28),
(149, 3, 11),
(150, 3, 12),
(162, 5, 32),
(179, 5, 35),
(170, 41, 31),
(432, 94, 18),
(434, 94, 20),
(173, 40, 7),
(435, 94, 21),
(175, 42, 15),
(180, 1, 35),
(181, 44, 35),
(182, 44, 17),
(431, 94, 17),
(184, 44, 24),
(185, 44, 33),
(186, 1, 36),
(436, 94, 23),
(433, 94, 19),
(189, 5, 36),
(190, 46, 31),
(191, 46, 36),
(192, 46, 30),
(193, 46, 20),
(194, 46,

,
(430, 94, 16),
(429, 94, 15),
(197, 1, 37),
(198, 1, 38),
(199, 48, 36),
(200, 5, 38),
(201, 5, 37),
(202, 25, 15),
(428, 94, 14),
(204, 1, 39),
(205, 5, 39),
(427, 94, 12),
(207, 1, 40),
(426, 94, 11),
(209, 5, 41),
(210, 1, 41),
(211, 5, 40),
(212, 46, 7),
(213, 1, 42),
(214, 18, 43),
(215, 11, 31),
(216, 11, 43),
(217, 1, 43),
(218, 11, 44),
(219, 1, 44),
(220, 11, 45),
(221, 1, 45),
(222, 11, 46),
(223, 11, 47),
(224, 1, 46),
(225, 1, 47),
(226, 11, 41),
(422, 94, 7),
(228, 5, 42),
(229, 5, 43),
(230, 5, 44),
(231, 5, 45),
(232, 5, 46),
(233, 5, 47),
(234, 37, 19),
(235, 5, 48),
(236, 1, 48),
(237, 5, 49),
(238, 1, 49),
(239, 3, 35),
(240, 3, 33),
(241, 37, 48),
(242, 37, 50),
(243, 5, 50),
(244, 44, 47),
(245, 3, 50),
(424, 94, 9),
(419, 94, 4),
(248, 5, 51),
(418, 10, 31),
(250, 4, 50),
(251, 4, 41),
(252, 4, 31),
(253, 4, 30),
(260, 1, 51),
(259, 1, 52),
(420, 94, 5),
(257, 18, 41),
(258, 18, 36),
(261, 1, 50),
(425, 94, 10),
(263, 53, 42),
(264, 37, 54),
(265, 1, 54),
(417, 10, 30),
(267, 44, 15),
(268, 5, 54),
(269, 11, 52),
(270, 11, 49),
(271, 5, 55),
(272, 1, 55),
(273, 59, 33),
(274, 60, 36),
(275, 60, 52),
(276, 60, 51),
(277, 60, 46),
(278, 57, 33),
(279, 61, 30),
(280, 61, 42),
(281, 4, 14),
(282, 61, 33),
(283, 37, 35),
(284, 59, 27),
(416, 10, 70),
(286, 11, 30),
(287, 54, 52),
(620, 59, 68),
(289, 62, 27),
(290, 62, 20),
(619, 92, 76),
(415, 91, 5),
(618, 98, 31),
(294, 37, 49),
(295, 37, 29),
(617, 98, 30),
(297, 44, 45),
(298, 44, 43),
(299, 44, 27),
(300, 54, 23),
(301, 54, 17),
(302, 54, 18),
(303, 46, 33),
(304, 1, 57),
(305, 5, 57),
(306, 57, 58),
(307, 1, 58),
(308, 5, 58),
(309, 57, 38),
(310, 57, 31),
(311, 57, 30),
(312, 57, 25),
(313, 63, 35),
(314, 63, 59),
(315, 5, 59),
(316, 44, 23),
(414, 91, 30),
(318, 1, 59),
(319, 65, 35),
(320, 5, 52),
(321, 37, 39),
(322, 66, 60),
(323, 1, 60),
(324, 11, 57),
(325, 11, 40),
(326, 5, 60),
(327, 37, 61),
(616, 1, 75),
(329, 5, 61),
(330, 59, 35),
(331, 1, 61),
(332, 37, 62),
(333, 5, 62),
(334, 37, 63),
(335, 5, 63),
(336, 46, 52),
(337, 1, 62),
(338, 1, 63),
(339, 20, 31),
(340, 20, 30),
(341, 25, 41),
(342, 57, 63),
(343, 26, 60),
(344, 26, 30),
(345, 37, 9),
(346, 71, 35),
(347, 71, 62),
(348, 71, 33),
(349, 71, 58),
(350, 1, 64),
(351, 66, 35),
(352, 7, 47),
(353, 46, 41),
(354, 66, 42),
(355, 66, 65),
(356, 66, 58),
(357, 1, 66),
(358, 4, 57),
(359, 75, 35),
(360, 10, 7),
(361, 10, 58),
(362, 10, 38),
(363, 5, 66),
(364, 11, 66),
(365, 11, 64),
(366, 77, 35),
(367, 77, 33),
(368, 20, 20),
(369, 1, 67),
(411, 74, 9),
(371, 16, 57),
(372, 80, 23),
(373, 80, 17),
(374, 80, 68),
(375, 1, 68),
(376, 80, 30),
(377, 5, 68),
(378, 1, 69),
(379, 4, 67),
(380, 25, 67),
(381, 81, 69),
(382, 81, 70),
(383, 1, 70),
(384, 81, 71),
(385, 5, 70),
(386, 5, 71),
(387, 5, 69),
(388, 1, 71),
(389, 83, 31),
(390, 83, 30),
(391, 84, 35),
(392, 84, 31),
(393, 84, 23),
(394, 26, 45),
(395, 59, 69),
(396, 4, 71),
(615, 1, 74),
(408, 89, 46),
(399, 4, 39),
(400, 85, 47),
(452, 94, 40),
(409, 89, 20),
(410, 89, 35),
(412, 11, 55),
(413, 91, 31),
(421, 94, 6),
(423, 94,

,
(453, 94, 41),
(454, 94, 42),
(455, 94, 43),
(456, 94, 44),
(457, 94, 45),
(458, 94, 46),
(459, 94, 47),
(460, 94, 48),
(461, 94, 49),
(462, 94, 50),
(463, 94, 51),
(464, 94, 52),
(465, 94, 54),
(466, 94, 55),
(614, 1, 73),
(468, 94, 57),
(469, 94, 58),
(470, 94, 59),
(471, 94, 60),
(472, 94, 61),
(473, 94, 62),
(474, 94, 63),
(475, 94, 64),
(476, 94, 66),
(477, 94, 67),
(478, 94, 68),
(479, 94, 69),
(480, 94, 70),
(481, 94, 71),
(482, 92, 4),
(483, 92, 5),
(484, 92, 6),
(485, 92, 7),
(486, 92,

,
(487, 92, 9),
(488, 92, 10),
(489, 92, 11),
(490, 92, 12),
(491, 92, 14),
(492, 92, 15),
(493, 92, 16),
(494, 92, 17),
(495, 92, 18),
(496, 92, 19),
(497, 92, 20),
(498, 92, 21),
(499, 92, 23),
(500, 92, 24),
(501, 92, 25),
(502, 92, 26),
(503, 92, 27),
(504, 92, 28),
(505, 92, 29),
(506, 92, 30),
(507, 92, 31),
(508, 92, 32),
(509, 92, 33),
(510, 92, 35),
(511, 92, 36),
(512, 92, 37),
(513, 92, 38),
(514, 92, 39),
(515, 92, 40),
(516, 92, 41),
(517, 92, 42),
(518, 92, 43),
(519, 92, 44),
(520, 92, 45),
(521, 92, 46),
(522, 92, 47),
(523, 92, 48),
(524, 92, 49),
(525, 92, 50),
(526, 92, 51),
(527, 92, 52),
(528, 92, 54),
(529, 92, 55),
(613, 1, 72),
(531, 92, 57),
(532, 92, 58),
(533, 92, 59),
(534, 92, 60),
(535, 92, 61),
(536, 92, 62),
(537, 92, 63),
(538, 92, 64),
(539, 92, 66),
(540, 92, 67),
(541, 92, 68),
(542, 92, 69),
(543, 92, 70),
(544, 92, 71),
(545, 26, 67),
(546, 95, 4),
(547, 95, 5),
(548, 95, 6),
(549, 95, 7),
(550, 95,

,
(551, 95, 9),
(552, 95, 10),
(553, 95, 11),
(554, 95, 12),
(555, 95, 14),
(556, 95, 15),
(557, 95, 16),
(558, 95, 17),
(559, 95, 18),
(560, 95, 19),
(561, 95, 20),
(562, 95, 21),
(563, 95, 23),
(564, 95, 24),
(565, 95, 25),
(566, 95, 26),
(567, 95, 27),
(568, 95, 28),
(569, 95, 29),
(570, 95, 30),
(571, 95, 31),
(572, 95, 32),
(573, 95, 33),
(574, 95, 35),
(575, 95, 36),
(576, 95, 37),
(577, 95, 38),
(578, 95, 39),
(579, 95, 40),
(580, 95, 41),
(581, 95, 42),
(582, 95, 43),
(583, 95, 44),
(584, 95, 45),
(585, 95, 46),
(586, 95, 47),
(587, 95, 48),
(588, 95, 49),
(589, 95, 50),
(590, 95, 51),
(591, 95, 52),
(592, 95, 54),
(593, 95, 55),
(612, 5, 75),
(595, 95, 57),
(596, 95, 58),
(597, 95, 59),
(598, 95, 60),
(599, 95, 61),
(600, 95, 62),
(601, 95, 63),
(602, 95, 64),
(603, 95, 66),
(604, 95, 67),
(605, 95, 68),
(606, 95, 69),
(607, 95, 70),
(608, 95, 71),
(609, 5, 72),
(610, 5, 73),
(611, 5, 74),
(621, 53, 78),
(622, 1, 78),
(623, 53, 79),
(624, 53, 33),
(625, 53, 28),
(626, 1, 80),
(627, 53, 81),
(628, 5, 80),
(629, 5, 81),
(630, 5, 79),
(631, 55, 23),
(632, 53, 82),
(633, 53, 83),
(634, 53, 84),
(635, 53, 7),
(636, 1, 82),
(637, 1, 83),
(638, 1, 84),
(639, 53, 85),
(640, 53, 9),
(641, 101, 31),
(642, 5, 85),
(643, 1, 81),
(644, 1, 85),
(646, 53, 43),
(647, 53, 69),
(648, 53, 80),
(649, 53, 55),
(651, 1, 87),
(652, 103, 31),
(653, 53, 88),
(654, 1, 89),
(655, 53, 90),
(656, 53, 91),
(657, 53, 92),
(658, 53, 93),
(659, 53, 94),
(660, 53, 95),
(661, 104, 31),
(663, 53, 96),
(664, 1, 97),
(665, 53, 98),
(666, 53, 99),
(667, 1, 91),
(668, 1, 98),
(669, 53, 100),
(670, 1, 100),
(671, 1, 88),
(672, 53, 89),
(673, 1, 94),
(674, 67, 31),
(675, 4, 87),
(676, 99, 67),
(677, 4, 80),
(678, 99, 75),
(679, 99, 29),
(680, 99, 48),
(681, 99, 74),
(682, 5, 87),
(683, 108, 73),
(684, 108,

,
(685, 108, 15),
(686, 1, 101),
(691, 5, 101),
(692, 102, 45),
(693, 63, 89),
(690, 106, 101),
(694, 63, 55),
(695, 9, 42),
(696, 5, 99),
(697, 111, 9),
(698, 111, 31),
(699, 111, 97),
(700, 7, 89),
(701, 7, 101),
(702, 25, 101),
(703, 112, 94),
(704, 112, 31),
(705, 5, 90),
(707, 115, 7),
(710, 53, 103),
(711, 1, 103),
(712, 53, 57),
(713, 5, 103),
(714, 53, 104),
(715, 1, 105),
(716, 53, 97),
(717, 5, 105),
(718, 4, 105),
(719, 4, 104),
(720, 63, 98),
(721, 81, 97),
(722, 118, 89),
(723, 115, 106),
(724, 115, 107),
(725, 1, 107),
(726, 1, 106),
(727, 11, 104),
(728, 11, 101),
(729, 11, 94),
(730, 11, 108),
(731, 55, 103),
(732, 11, 109),
(733, 11, 15),
(734, 11, 110),
(735, 5, 108),
(736, 5, 109),
(737, 1, 109),
(738, 11, 103),
(739, 20, 103),
(740, 89, 107),
(741, 110, 31),
(742, 52, 109),
(743, 52, 105),
(744, 52, 103),
(745, 52, 97),
(746, 52, 94),
(747, 52, 87),
(749, 123, 69),
(750, 124, 36),
(751, 124, 20),
(752, 124, 10),
(753, 1, 104),
(754, 81, 111),
(755, 5, 111),
(756, 5, 104),
(758, 5, 97),
(759, 81, 112),
(760, 1, 111),
(761, 1, 112),
(762, 5, 112),
(763, 5, 89),
(764, 81, 89),
(765, 102, 7),
(766, 102, 105),
(767, 102, 104),
(769, 81, 98),
(770, 81, 103),
(806, 133, 94),
(772, 81, 7),
(773, 81, 113),
(774, 1, 113),
(775, 81, 80),
(805, 102, 94),
(804, 1, 108),
(778, 81, 115),
(803, 55, 31),
(780, 53, 115),
(781, 81, 96),
(782, 1, 115),
(802, 5, 113),
(784, 81, 81),
(801, 130, 89),
(800, 53, 102),
(787, 25, 113),
(799, 53, 114),
(789, 5, 115),
(790, 81, 117),
(798, 53, 116),
(792, 1, 117),
(793, 128, 31),
(797, 130, 66),
(795, 5, 98),
(796, 5, 117);

Это не таблица с торрентами. Эта таблица с просмотрами и т.д. Название таблици переведи.
readtorrents:
read - чтение, torrents - торренты.
Вы сделали не ту копию не той таблици

После того как я установил другой двиг я восстановил таблицу с торрентами, но когда захожув любой из них на трекере пишется:
Нет торрента с таким ID.
Вот теперь я не знаю как сделать так чтобы не было такой ошибки.
Подскажите как исправить.

Уважаемые ..а как енту весчь поставить вообще, куда кидать?что делать?

Форум сервиса вфосе.ру

Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin

Re: Работа с MySql в phpMyAdmin