Ich habe komische Probleme mit den Mysqldump.
Manche Felder werden nicht korrekt herausgegeben:
Code: Select all
DROP TABLE IF EXISTS divelogPlace;
CREATE TABLE divelogPlace (
ID int(11) auto_increment,
CountryID int(11) default NULL,
Place varchar(255) default '',
Rating int(11) default NULL,
MaxDepth double default NULL,
Lat double default NULL,
Lon double default NULL,
MapPath varchar(255) default '',
Map blob default NULL,
Comments text,
PRIMARY KEY (ID)
) TYPE=MyISAM;
#
# Data for table 'divelogPlace'
#
INSERT INTO divelogPlace VALUES (1, 0, 'Grasbroek', NULL, 15, NULL, NULL, '', '', '');
INSERT INTO divelogPlace VALUES (2, 0, 'Bussloo', NULL, NULL, NULL, NULL, '', '', '');
INSERT INTO divelogPlace VALUES (3, 0, 'Diveworld', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (4, 0, 'Dreischor', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (5, 0, 'Oostvoornse Meer', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (6, 0, 'Lingen', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (7, 0, 'Ten Osch', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (8, 0, 'Den Osse', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (9, 0, 'Zeelandbrug', NULL, NULL, , , , '', '');
INSERT INTO divelogPlace VALUES (10, 0, '''t Koepeltje', NULL, NULL, , , , '', '');
Auf der 3. kommt jedoch ein Fehler:
Code: Select all
Error:
in INSERT INTO divelogPlace
VALUES ( 3, 0, 'Diveworld', NULL , NULL , , , , '', '' )
Grüße, Martijn