Hey, I would add the NAVDATA.SQL to my MySQL-Database, but when i try to add it, I become this error:
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, kundenservice@goneo.de and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Yes I read the manual to add the navdata!
Hey, I would add the NAVDATA.SQL to my MySQL-Database, but when i try to add it, I become this error:
Yes I read the manual to add the navdata!
Maybe the file it to big to handle for your server. I did get a time out error because it took the server too long to import everything.
I imported the file in parts.
Regards,
Cor
can you give me this parts? I have very big problems to do this. Or gives for this a software??
You first need to know if that is really the problem at your server and how big are the files your server can handle. I copy and paste
part for part. Each part containend a amount of lines, I think between around the 10.000 or 15.000 lines each time.
Regards,
Cor
yes with 10000 works it. But I cant only add the first. After this i cant, I think i forget what, but what?
Can you please help me? Eventually give me your files…
I did it with copy and paste. Dont forget to start your import with INSERT INTO phpvms_navdata` VALUES .
So if you did the first 10000, then the next batch has to start as
INSERT INTO
phpvms_navdataVALUES(10001,‘NOSPI’,‘’,‘G117’,‘B’,5750,‘ASA’,53.810001,86.878334,‘’,3),(10002,‘ER’,‘ELLISRAS’,‘G118’,‘B’,5700,‘’,-23.748610,27.623333,‘’,3),(10003,‘OGURA’,‘’,‘G118’,‘B’,5705,‘ASA’,47.125000,40.450001,‘’,3),(10004,‘BA’,‘BABCO’,‘G118’,‘B’,5710,‘ASA’,47.316666,40.366669,‘’,3),(10005,‘KL’,‘Kalibo’,‘G118’,‘B’,5720,‘ASA’,47.883331,40.099998,‘113.00’,3),
Regards,
Cor
I did it with copy and paste. Don
t forget to start your import with INSERT INTOphpvms_navdata` VALUES .So if you did the first 10000, then the next batch has to start as
Regards,
Cor
okay thx
Ok, maybe you can help me here…
I want to export my sql data to excel. I have basically done what you guys are talking about, by separating it in amounts of 3000, 5000, 10000. But once exported to .csv format, excel will NOT read it properly. Keeps saying too many rows or columns. I must be missing something simple here. I just want to be able to edit/correct the data in stages, to make one complete big file.