mischka Posted September 11, 2012 Report Share Posted September 11, 2012 Hello In my install package I found a file called navdata.sql which seems to contain sql statements that create a table with data about navigation aids. This is all very well,but the file is so big that none of my text editors can open it: they all crash. Not to mention copying and pasting it to the phpmyadmin and executing it Is there any way around it? Any tools or maybe this tabledata is available somewhere as a csv file to normally import to phpmyadmin? grtz Mischka Quote Link to comment Share on other sites More sharing options...
Moderators servetas Posted September 11, 2012 Moderators Report Share Posted September 11, 2012 I think that it will be run during the installation process. Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted September 11, 2012 Report Share Posted September 11, 2012 Just import directly into phpadmin. No need to open it. Use the "IMPORT" tab on the table. It will work Quote Link to comment Share on other sites More sharing options...
mischka Posted September 11, 2012 Author Report Share Posted September 11, 2012 Nah, gives me internal server errors when I try to import it on phpmyadmin booooooring... Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted September 11, 2012 Moderators Report Share Posted September 11, 2012 not boring just not the correct settings of your server Quote Link to comment Share on other sites More sharing options...
mischka Posted September 11, 2012 Author Report Share Posted September 11, 2012 Yeah, I suppose so.. but how to change it? Could anyone dump this for me in a csv file? Its probably even smaller than the sql file... Quote Link to comment Share on other sites More sharing options...
piuozorio Posted September 11, 2012 Report Share Posted September 11, 2012 Hello all, for sure your mysql is limited to not import more than X MB. You can change the value, i think somewhere related with mysql or in php.ini, not sure. You have another option, i used in past one or two times and worked perfectly, take a look BIGDUMP http://www.ozerov.de/bigdump/ , this is more for very large .sql files like backups. Hope it helps 2 Quote Link to comment Share on other sites More sharing options...
mischka Posted September 11, 2012 Author Report Share Posted September 11, 2012 Piuzioro, you made my day! The first assumption, of file limitation, did not apply cause my file limit was 20Mb and the file was 6ish But bigdump actually worked pretty well, and I now have the data in both my vms databases. The first I did with bigdump, then I made a csv export and imported that into the other database. Works like a charm and no need upload or execute scripts. To save anyone else all this hassle, here's the CSV file: phpvms_navdata.csv Keep in mind this has the column names in it so remove these from the file or set the import to skip the first row. Thanks again for piuzorio for putting me on to bigdump! 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.