@morfik
Just remove your country and import it again in your backoffice.

But removing a country also removes all ads posted.....

So how to import this without removing ads?

Drop foreign keys and update, update, update...

Drop foreign keys and update, update, update...

How to drop them, can you elaborate a little bit? I mean any names? What do we need to drop?

I also need more precise instructions.

Interesting observation.

All pk_i_id in t_region seems to be similar to the previous ones except that they start with different number now. So for instance:

(2858791, 'PL', 'Warmia-Masuria', 1, 'warmia-masuria'),
(5337492, 'PL', 'Lower Silesia', 1, 'lower-silesia'),
vs.

(3858791, 'PL', 'Warmia-Masuria', 1, 'warmia-masuria'),
(6337492, 'PL', 'Lower Silesia', 1, 'lower-silesia'),
So all the numbers with 2 in the first place, now have 3 in that position. The same with 5 > 6.The rest of the numbers is the same.

Similar with cities, i.e. pk_i_id and fk_i_region_id :

(2776808, 2858785, 'PL', 'Abramów', 1, 'abramow', 51.45647, 22.31521),
(5079846, 5337492, 'PL', 'Pasiecznik', 1, 'pasiecznik', 50.9568, 15.57209),
vs.

(3776808, 3858785, 'PL', 'Abramów', 1, 'abramow', 51.45647, 22.31521),
(6079846, 6337492, 'PL', 'Pasiecznik', 1, 'pasiecznik', 50.9568, 15.57209),
So why?

I think I could just change (2 > (3 and (5 > (6 , save the file and import it. Older entries would have older IDs. Am I thinking right?

I've managed to do it manually via phpmyadmin and couple export/import tables (with changed values). Basically if someone has already published a lot of ads, I don't think there's a way to import the new database. I think in such case, it's better to change the first numbers of the primary i foreign keys and import such database.

I have a question, what's the t_locations_tmp table used for? It looks like it has city keys. But since it's TMP, can it be cleared out safely?

Cron took care of it I suppose. So after updating the database It's nice to run all the cron jobs, to update what should be regenerated.

It's probably used for import