Jump to content

[SOLVED]Adding NavData failed


BastiDE

Recommended Posts

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!

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...