New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Can't import correctly the gplanet.sql.zip #2
Comments
Thanks for the notice. The SQL was generated using mysqldump, so I suspect some sort of version conflict. Will investigate. What output are you getting for the import method? It should echo status to stdout. |
Try the SQL file I've uploaded temporarily to https://www.dropbox.com/s/6m1lhepltm4vjfg/gplplanet.sql.zip It was generated using the command:
If it solves your problem, I'll upload it to the repo. Let me know how you get on. |
I was tryed it, but we have a same problem unfortunetly. The import method with php was told me, everything is good, but most of my tables are empty. I was tryed to use directly the sql file, but Mysql told me that notice:
also this message, when I was try to run sql with mysql40 compatibility mode. after all, i was tryed the php import method again (with the partially filled database) and it was told me following output, and nothing was changed at the stock of the database.
|
Can you share with me the mysql import command you are using please. |
I was used phpMyAdmin. Is it a problem? |
I think that could be the problem -- it's a big file and I would not trust a web interface not to choke. You OK to try the cmdln? |
it's ok but never tried earlier. there is my full console history. Was I did something wrong? (the geo database was created manually. At this status it's full empty)
|
I know what maybe the problem. There is no charset informations at the sql. two diferent sql. The first is work, the second is not:
The second is copyed from the sql |
I was created a little snippet to upload the database correctly: Maybe it's helpful:
|
Link to SQL version with complete create table syntax: https://www.dropbox.com/sh/kmucg7f929c7lpo/BoCR7Dl7W9
|
Thank you, it's work, until the mysql tell this:
It was happend when mysql was tryed to fill geo_descendants. 30,953 row is there, but no more, it always crashing here (for me). I think, this is maybe, becouse that query string is too large. Is it possible? Can I break it to smaller particles some how? |
Try increasing your max packet to 2gb |
There will always be an error for direct import the 'geoplanet.sql.zip':
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`que' at line 3
If I run the php import method it say I'ts complete, but the database geo_places table will get just one row, whith NULL values, and the geo_placenames wil uploaded by same kind of empty or 0 values. The geo_countries is good! there is ~2,598 row. Butever the api doesn't work. forexample /webservice/get.php?woeid=23424739 will return an empty answer. What can I do?
thx for help!
The text was updated successfully, but these errors were encountered: