Probleme mit MySql befehl

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Probleme mit MySql befehl

Postby dodasports » 26. February 2007 15:55

ich hab ein backup meiner datenbank gemacht und wollte es nun wieder draufspielen. Es kommt aber folgender Fehler:

hab eine tabelle exportiert (PHPmyAdmin). Sieh sieht wie folgt aus:

SQL-Befehl:

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. Februar 2007 um 15:41
-- Server Version: 4.1.22
-- PHP-Version: 4.4.5
--
-- Datenbank: `dodasports`
-- -------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `webs_user_visitors`
--
CREATE TABLE `webs_user_visitors` (
`visitID` int( 11 ) NOT NULL default '0',
`userID` int( 11 ) NOT NULL default '0',
`visitor` int( 11 ) NOT NULL default '0',
`date` int( 14 ) NOT NULL default '0'
) TYPE = MYISAM

MySQL meldet: Dokumentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- www.phpmyadmin.net
--
' at line 1







So sieht das backUp aus:




-- phpMyAdmin SQL Dump
-- version 2.6.4-pl4
-- www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. Februar 2007 um 15:41
-- Server Version: 4.1.22
-- PHP-Version: 4.4.5
--
-- Datenbank: `dodasports`

-- -------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `webs_user_visitors`
--

CREATE TABLE `webs_user_visitors` (
`visitID` int(11) NOT NULL default '0',
`userID` int(11) NOT NULL default '0',
`visitor` int(11) NOT NULL default '0',
`date` int(14) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Daten für Tabelle `webs_user_visitors`
--

INSERT INTO `webs_user_visitors` VALUES (1, 6, 1, 1167415891);
INSERT INTO `webs_user_visitors` VALUES (2, 5, 1, 117017521cool;
INSERT INTO `webs_user_visitors` VALUES (3, 4, 1, 1167478312);
INSERT INTO `webs_user_visitors` VALUES (4, 7, 5, 1167482177);
INSERT INTO `webs_user_visitors` VALUES (5, 1, 5, 1167573801);
INSERT INTO `webs_user_visitors` VALUES (6, 4, 5, 1167420822);
INSERT INTO `webs_user_visitors` VALUES (7, 5, 7, 1167422920);
INSERT INTO `webs_user_visitors` VALUES (8, 6, 7, 1167506352);
INSERT INTO `webs_user_visitors` VALUES (9, 7, 1, 1171474459);
INSERT INTO `webs_user_visitors` VALUES (10, 9, 8, 1167579121);
INSERT INTO `webs_user_visitors` VALUES (11, 8, 1, 116758255cool;
INSERT INTO `webs_user_visitors` VALUES (12, 1, 9, 1168457725);
INSERT INTO `webs_user_visitors` VALUES (13, 5, 9, 116767438cool;
INSERT INTO `webs_user_visitors` VALUES (14, 9, 1, 1168975986);
INSERT INTO `webs_user_visitors` VALUES (15, 11, 1, 1168602113);
INSERT INTO `webs_user_visitors` VALUES (16, 1, 11, 1168206435);
INSERT INTO `webs_user_visitors` VALUES (17, 5, 11, 1168206422);
INSERT INTO `webs_user_visitors` VALUES (18, 7, 11, 1168206445);
INSERT INTO `webs_user_visitors` VALUES (19, 9, 11, 1168206451);
INSERT INTO `webs_user_visitors` VALUES (20, 1, 7, 1170936286);
INSERT INTO `webs_user_visitors` VALUES (21, 4, 9, 1168457755);
INSERT INTO `webs_user_visitors` VALUES (22, 7, 9, 1168457776);
INSERT INTO `webs_user_visitors` VALUES (23, 12, 1, 1170536740);
INSERT INTO `webs_user_visitors` VALUES (24, 7, 12, 1168794685);
INSERT INTO `webs_user_visitors` VALUES (25, 6, 12, 116886794cool;
INSERT INTO `webs_user_visitors` VALUES (26, 12, 7, 116880142cool;
INSERT INTO `webs_user_visitors` VALUES (27, 10, 7, 1168801735);
INSERT INTO `webs_user_visitors` VALUES (28, 4, 7, 1168801871);
INSERT INTO `webs_user_visitors` VALUES (29, 9, 7, 1168804127);
INSERT INTO `webs_user_visitors` VALUES (30, 11, 7, 1168805103);
INSERT INTO `webs_user_visitors` VALUES (31, 13, 7, 1168804150);
INSERT INTO `webs_user_visitors` VALUES (32, 13, 12, 1168867942);
INSERT INTO `webs_user_visitors` VALUES (33, 13, 1, 1170536742);
INSERT INTO `webs_user_visitors` VALUES (34, 14, 13, 1169074202);
INSERT INTO `webs_user_visitors` VALUES (35, 7, 13, 1169117805);
INSERT INTO `webs_user_visitors` VALUES (36, 13, 5, 1169134652);
INSERT INTO `webs_user_visitors` VALUES (37, 14, 1, 116920786cool;
INSERT INTO `webs_user_visitors` VALUES (38, 10, 1, 1169758645);
INSERT INTO `webs_user_visitors` VALUES (39, 16, 1, 1170278215);
INSERT INTO `webs_user_visitors` VALUES (40, 5, 18, 1169993472);
INSERT INTO `webs_user_visitors` VALUES (41, 1, 18, 1169990450);
INSERT INTO `webs_user_visitors` VALUES (42, 9, 18, 1169989669);
INSERT INTO `webs_user_visitors` VALUES (43, 16, 18, 1169997070);
INSERT INTO `webs_user_visitors` VALUES (44, 18, 1, 1170016127);
INSERT INTO `webs_user_visitors` VALUES (45, 20, 1, 1171219217);
INSERT INTO `webs_user_visitors` VALUES (46, 18, 7, 117009314cool;
INSERT INTO `webs_user_visitors` VALUES (47, 21, 1, 1171132775);
INSERT INTO `webs_user_visitors` VALUES (48, 23, 1, 1170708451);
INSERT INTO `webs_user_visitors` VALUES (49, 13, 23, 1170525533);
INSERT INTO `webs_user_visitors` VALUES (50, 12, 23, 1170525830);
INSERT INTO `webs_user_visitors` VALUES (51, 14, 23, 1170525633);
INSERT INTO `webs_user_visitors` VALUES (52, 1, 23, 1170525729);
INSERT INTO `webs_user_visitors` VALUES (53, 7, 23, 1170525777);
INSERT INTO `webs_user_visitors` VALUES (54, 31, 1, 1171657400);
INSERT INTO `webs_user_visitors` VALUES (55, 36, 1, 1170795294);
INSERT INTO `webs_user_visitors` VALUES (56, 31, 37, 1171996997);
INSERT INTO `webs_user_visitors` VALUES (57, 1, 37, 117079723cool;
INSERT INTO `webs_user_visitors` VALUES (58, 26, 37, 1170797314);
INSERT INTO `webs_user_visitors` VALUES (59, 10, 37, 1170797423);
INSERT INTO `webs_user_visitors` VALUES (60, 21, 37, 1170797349);
INSERT INTO `webs_user_visitors` VALUES (61, 20, 37, 117079738cool;
INSERT INTO `webs_user_visitors` VALUES (62, 28, 37, 1170797395);
INSERT INTO `webs_user_visitors` VALUES (63, 19, 37, 117079743cool;
INSERT INTO `webs_user_visitors` VALUES (64, 16, 37, 1170797446);
INSERT INTO `webs_user_visitors` VALUES (65, 37, 1, 1172136000);
INSERT INTO `webs_user_visitors` VALUES (66, 17, 14, 1170859837);
INSERT INTO `webs_user_visitors` VALUES (67, 21, 14, 1170859846);
INSERT INTO `webs_user_visitors` VALUES (68, 7, 14, 1170952750);
INSERT INTO `webs_user_visitors` VALUES (69, 2, 1, 117137327cool;
INSERT INTO `webs_user_visitors` VALUES (70, 39, 1, 1170939199);
INSERT INTO `webs_user_visitors` VALUES (71, 12, 14, 1170952880);
INSERT INTO `webs_user_visitors` VALUES (72, 1, 40, 1171054557);
INSERT INTO `webs_user_visitors` VALUES (73, 38, 40, 1171005113);
INSERT INTO `webs_user_visitors` VALUES (74, 40, 1, 1171653477);
INSERT INTO `webs_user_visitors` VALUES (75, 37, 40, 1171348976);
INSERT INTO `webs_user_visitors` VALUES (76, 31, 40, 1171348957);
INSERT INTO `webs_user_visitors` VALUES (77, 21, 40, 1171005167);
INSERT INTO `webs_user_visitors` VALUES (78, 7, 40, 1171187557);
INSERT INTO `webs_user_visitors` VALUES (79, 16, 40, 1171005224);
INSERT INTO `webs_user_visitors` VALUES (80, 23, 40, 1171005245);
INSERT INTO `webs_user_visitors` VALUES (81, 9, 40, 1171005335);
INSERT INTO `webs_user_visitors` VALUES (82, 28, 40, 117105475cool;
INSERT INTO `webs_user_visitors` VALUES (83, 10, 40, 1171056609);
INSERT INTO `webs_user_visitors` VALUES (84, 31, 41, 1171146167);
INSERT INTO `webs_user_visitors` VALUES (85, 31, 42, 1172139550);
INSERT INTO `webs_user_visitors` VALUES (86, 40, 42, 1172139573);
INSERT INTO `webs_user_visitors` VALUES (87, 16, 42, 1171292510);
INSERT INTO `webs_user_visitors` VALUES (88, 42, 1, 1171303076);
INSERT INTO `webs_user_visitors` VALUES (89, 42, 40, 1171398502);
INSERT INTO `webs_user_visitors` VALUES (90, 44, 40, 1171481639);
INSERT INTO `webs_user_visitors` VALUES (91, 1, 44, 1171703563);
INSERT INTO `webs_user_visitors` VALUES (92, 42, 44, 1171703652);
INSERT INTO `webs_user_visitors` VALUES (93, 40, 44, 1171482026);
INSERT INTO `webs_user_visitors` VALUES (94, 46, 1, 1171569099);
INSERT INTO `webs_user_visitors` VALUES (95, 43, 1, 117156950cool;
INSERT INTO `webs_user_visitors` VALUES (96, 44, 1, 1171653470);
INSERT INTO `webs_user_visitors` VALUES (97, 7, 46, 1171645750);
INSERT INTO `webs_user_visitors` VALUES (98, 13, 46, 1171645814);
INSERT INTO `webs_user_visitors` VALUES (99, 23, 46, 1171646041);
INSERT INTO `webs_user_visitors` VALUES (100, 45, 46, 1171646067);
INSERT INTO `webs_user_visitors` VALUES (101, 41, 1, 1171653465);
INSERT INTO `webs_user_visitors` VALUES (102, 43, 44, 1171702056);
INSERT INTO `webs_user_visitors` VALUES (103, 7, 37, 1171997073);
INSERT INTO `webs_user_visitors` VALUES (104, 37, 42, 1172407660);
INSERT INTO `webs_user_visitors` VALUES (105, 1, 42, 117213914cool;
INSERT INTO `webs_user_visitors` VALUES (106, 21, 42, 1172139562);
INSERT INTO `webs_user_visitors` VALUES (107, 7, 42, 1172139567);
INSERT INTO `webs_user_visitors` VALUES (108, 44, 42, 1172139579);
INSERT INTO `webs_user_visitors` VALUES (109, 31, 7, 1172145417);
INSERT INTO `webs_user_visitors` VALUES (110, 37, 7, 1172145422);
INSERT INTO `webs_user_visitors` VALUES (0, 39, 42, 1172407652);
dodasports
 
Posts: 1
Joined: 26. February 2007 15:53

Postby sari42 » 28. February 2007 19:42

mach ne kopie und lösch einfach mal alle kommentare
sari42
 
Posts: 800
Joined: 27. November 2005 18:28


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 6 guests