[Tutorial] GeoIP and handling rangebans with MySQL

Linear Mode

[Tutorial] GeoIP and handling rangebans with MySQL

eSPeZet
Little Clucker

Posts: 34
Threads: 5
Joined: Jul 2017
Reputation: 0

#33

13.02.2018, 21:09

Every single step worked like a charm, except the importing..
When I import a few lines (as a test) with the sql console, then it works fine..but i can not do that with 168k lines..So i had to take MySQL Workbench (connected to my Host who has Linux) and i am getting this error, when I try to import:

ERROR 1452 (23000) at line 1: Cannot add or update a child row: a foreign key constraint fails (samp.list_ipv4, CONSTRAINT fk_ipv4_countrycode FOREIGN KEY (country_code) REFERENCES list_countries (country_code))
Operation failed with exitcode 1

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

GeoIP and handling rangebans with MySQL - by Vince - 18.08.2015, 13:29

Re: GeoIP and handling rangebans with MySQL - by Abagail - 18.08.2015, 14:52

Re: GeoIP and handling rangebans with MySQL - by Crystallize - 18.08.2015, 15:17

Re: GeoIP and handling rangebans with MySQL - by ThePhenix - 19.08.2015, 04:31

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 19.08.2015, 09:59

Re: GeoIP and handling rangebans with MySQL - by Glossy42O - 19.08.2015, 10:04

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 20.08.2015, 11:29

Re: GeoIP and handling rangebans with MySQL - by Kar - 21.08.2015, 00:14

Re: GeoIP and handling rangebans with MySQL - by Vince - 21.08.2015, 07:04

Re: GeoIP and handling rangebans with MySQL - by Kyle - 21.08.2015, 19:56

Re: GeoIP and handling rangebans with MySQL - by PaulDinam - 22.08.2015, 02:40

Re: GeoIP and handling rangebans with MySQL - by Pottus - 22.08.2015, 02:59

Re: GeoIP and handling rangebans with MySQL - by Kyle - 22.08.2015, 15:06

Re: GeoIP and handling rangebans with MySQL - by Abagail - 23.08.2015, 02:50

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 23.08.2015, 07:08

Re: GeoIP and handling rangebans with MySQL - by Vince - 23.08.2015, 09:49

Re: GeoIP and handling rangebans with MySQL - by Kyle - 23.08.2015, 10:05

Re: GeoIP and handling rangebans with MySQL - by JeaSon - 23.08.2015, 11:10

Re: GeoIP and handling rangebans with MySQL - by Yousha - 15.01.2016, 22:17

Re: GeoIP and handling rangebans with MySQL - by Vince - 15.01.2016, 22:47

Re: GeoIP and handling rangebans with MySQL - by raddetine - 13.04.2016, 15:34

Re: GeoIP and handling rangebans with MySQL - by ScIrUsna - 13.04.2016, 17:00

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 21.11.2016, 07:18

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 21.11.2016, 10:53

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 11:56

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 14.12.2016, 13:33

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 14:03

Re: GeoIP and handling rangebans with MySQL - by Konstantinos - 14.12.2016, 14:10

Re: GeoIP and handling rangebans with MySQL - by DetoNater - 14.12.2016, 14:47

Re: GeoIP and handling rangebans with MySQL - by X337 - 14.12.2016, 14:53

Re: GeoIP and handling rangebans with MySQL - by Evocator - 10.09.2017, 08:52

Re: GeoIP and handling rangebans with MySQL - by Vince - 10.09.2017, 09:34

Re: GeoIP and handling rangebans with MySQL - by eSPeZet - 13.02.2018, 21:09

View a Printable Version

Forum Jump:

Users browsing this thread: 2 Guest(s)