WORLDGUARD-2566 - Reported by Maddis

Hi there,
I wanted to set up worldguard with mysql, but could not even finish the setup. I imported region_storage.sql and after that I tried to import region_storage_update_20110325.sql, but that failed with the following message:
ERROR 1025 (HY000) at line 7: Error on rename of '.\worldguard\region_flag' to '.\worldguard#sql2-5d4-4' (errno: 152)

Without that update sql file I cannot run /region migratedb yaml mysql, because of "dubplicate entry for key PRIMARY". (A Google search lead me to the update.sql)

Thanks for your help

Comment by wizjany

ERROR 1025 (HY000) at line 7: Error on rename of '.\worldguard\region_flag' to '.\worldguard\#sql2-5d4-4' (errno: 152)```
 makes no sense at all, that's not even possible?

anyway, sql is not very well supported atm so i advise sticking with the yaml format for now
we might re-look at sql for 6.x

Comment by Maddis

"makes no sense at all, that's not even possible?"
That's what I thought.
SQL support would be great. Enables a lot of automatic backup routines and even web support.

Comment by wizjany

that kind of error means that the foreign key is incorrect somehow
i am no expert on sql but i think it means you screwed up importing the first file

Comment by Maddis

Well, it's not my first import. I inspected the first file a bit,
the first file contains a lot of the changes of the update file (maybe all), the foreign keys the file wants to drop do not exist anymore, so it seems the main issue could also be the "duplicate entry" which occurs while importing the working yaml files to the db via /region migratedb yaml mysql