Question regarding updating the database

  • Resolved wzshop

    (@wzshop)


    7 years, 4 months ago

    Hi,
    I have ‘Automatic download & update of Maxmind GeoIP Lite City’ selected, but just clicked the ‘update now’ button to initiate an immediate. The page loaded very long and turned to a 404. When I tried to update it manually afterwards, it said ‘File was not updated: It has not changed since the last update.’. Can I be sure the current file is complete or does it just check for a version note?

    Anyway, I have no idea if the current file I am hosting is complete. Maye it is better to manually download and update the database for once? Where can I download the file?

    Thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • Benjamin Pick

    (@benjamin4)

    7 years, 4 months ago

    You can delete the file (in your uploads-folder) and try again … or manually download it from https://dev.maxmind.com/geoip/geoip2/geolite2/

    Thread Starter wzshop

    (@wzshop)

    7 years, 4 months ago

    Thanks. When downloading; what precise file do i need to choose?
    GeoLite2 City
    GeoLite2 Country
    GeoLite2 ASN
    ? Thank you!

    • This reply was modified 7 years, 4 months ago by wzshop.
    • This reply was modified 7 years, 4 months ago by wzshop.
    • This reply was modified 7 years, 4 months ago by wzshop.
    Benjamin Pick

    (@benjamin4)

    7 years, 4 months ago

    City…

    Thread Starter wzshop

    (@wzshop)

    7 years, 4 months ago

    Hi,
    Thanks.
    One more question; does the update function also write something to the mysql database or is it just updating the city file?
    This way I know what PHP limits I need to increase, in order for it to make it work.
    Thanks

    Benjamin Pick

    (@benjamin4)

    7 years, 4 months ago

    No, there is no database involved. Probably you need to increase max_execution_time and maybe also memory_limit, that’s the usual suspect when a requests ends with a blank page.

    Thread Starter wzshop

    (@wzshop)

    7 years, 4 months ago

    okay, thanks!

    Thread Starter wzshop

    (@wzshop)

    7 years, 4 months ago

    Well, Ive tried multiple (shared) hosting providers with settings similar to the settings below. All i get is a 404 (page can’t be found) error, when I click the ‘update now’ button in wp-admin. Guess I will do a manual update then.

    -max_input_vars : 2000
    -max_execution_time: 7200
    -memory_limit : 2048M
    -post_max_size: 2048M
    -upload_max_filesize: 1G

Viewing 7 replies - 1 through 7 (of 7 total)

The topic ‘Question regarding updating the database’ is closed to new replies.