BastiDE Posted October 28, 2010 Report Share Posted October 28, 2010 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! Quote Link to comment Share on other sites More sharing options...
Cor Posted October 28, 2010 Report Share Posted October 28, 2010 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 Quote Link to comment Share on other sites More sharing options...
BastiDE Posted October 28, 2010 Author Report Share Posted October 28, 2010 can you give me this parts? I have very big problems to do this. Or gives for this a software?? Quote Link to comment Share on other sites More sharing options...
Cor Posted October 29, 2010 Report Share Posted October 29, 2010 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 Quote Link to comment Share on other sites More sharing options...
BastiDE Posted October 29, 2010 Author Report Share Posted October 29, 2010 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... Quote Link to comment Share on other sites More sharing options...
Cor Posted October 29, 2010 Report Share Posted October 29, 2010 I did it with copy and paste. Don`t 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_navdata` VALUES(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 Quote Link to comment Share on other sites More sharing options...
BastiDE Posted October 29, 2010 Author Report Share Posted October 29, 2010 I did it with copy and paste. Don`t 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 Regards, Cor okay thx Quote Link to comment Share on other sites More sharing options...
CPC900 Posted October 30, 2010 Report Share Posted October 30, 2010 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.