When run under the latest version of MySQL (8.0.12) (and perhaps others) import-dumps fails.
However, adding the following to the top of geonames_import_data.sql seems to fix it,
though I do not think this solution is good practice (with respect to security).
SET GLOBAL local_infile = 1;
...
When run under the latest version of MySQL (8.0.12) (and perhaps others)
import-dumpsfails.However, adding the following to the top of
geonames_import_data.sqlseems to fix it,though I do not think this solution is good practice (with respect to security).
SET GLOBAL local_infile = 1; ...