• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Need help with importing MySQL to phpmyadmin

E

Evil Styx

New Member
Joined
Jun 26, 2014
Messages
12
Reaction score
0
Hey,
I keep trying to either erase lines that give me errors or add things that people recommend, but more errors keep coming up. When i erased about 80% of the whole mysql.sql it actually worked, but i didn't have the tables. I'd appreciate any help, ill rep if you help, that's if you tell me how to rep.
the server im using, but i added a different datapack and stuff
[8.60] The Forgotten Server 0.3.6 (Crying Damson) V8

First error that comes up,

DROP TABLE IF EXISTS `players`;
MySQL said:
#1217 - Cannot delete or update a parent row: a foreign key constraint fails

I did try a couple other mysql.sql that were posted on forums i checked.

Another problem i have is that Remere's map editor won't open, it asks me to find tibia 8.6 that has tibia.spr and tibia.dat, but when i choose it, it wants me to find it again which makes no sense to me. I'll be checking for solutions all night probably, I'll post fixed or something if i fix it.

I'll be checking this post a lot, i hope someone helps.
Best Regards,
Evil Styx
 
Sort by date Sort by votes
Well.. you can not delete players table if you do not delete every other table that refers to players first. That's pretty much 80% of the tables. Why would you delete players table in the first place?

The second error is because 8.60 version had 2 different clients released, and the one you download from most websites is the wrong one. You can find the correct one in any RME post here.
 
Upvote 0 Downvote
Lordfire said:
Well.. you can not delete players table if you do not delete every other table that refers to players first. That's pretty much 80% of the tables. Why would you delete players table in the first place?

The second error is because 8.60 version had 2 different clients released, and the one you download from most websites is the wrong one. You can find the correct one in any RME post here.
Click to expand...

So i'm suppose to delete 80% of the table or what, i don't want to delete anything in the first place.. I got a SQLite server i think, and I REALLY want it MySQL, im still working on the server so i don't care about my account or anything.
 
Upvote 0 Downvote
So if you are using SQLite atm, and you're now trying to set up a new fresh MySQL database you should have no table "players" in MySQL? If I were you, I would drop the MySQL database you're importing to and start over.

About the RME file problem - download and install the client from here http://www.tibia.sx/ and try again. The problem comes with weird .exe install files.
 
Last edited by a moderator:
Upvote 0 Downvote
Let me explain better: there are hard connections between a lot of tables, for example: for an item to be on "player_items", there has to be an existing player for this item to be linked to. That's why you can not delete (drop) an entire table, because of those links (called foreign keys).

If you don't have a running server, then just create a fresh database, like trollebror said. Its less of a hassle.
 
Upvote 0 Downvote
Lordfire said:
Let me explain better: there are hard connections between a lot of tables, for example: for an item to be on "player_items", there has to be an existing player for this item to be linked to. That's why you can not delete (drop) an entire table, because of those links (called foreign keys).

If you don't have a running server, then just create a fresh database, like trollebror said. Its less of a hassle.
Click to expand...
In order to do that, do i have to erase xampp and download it again ,or is there a way to redo the database? (sorry, im new to making servers and stuff)

trollebror said:
About the RME file problem - download and install the client from here http://www.tibia.sx/ and try again. The problem comes with weird .exe install files.
Click to expand...
Is there a place i have to download RME from? Because i download tibia from the link you gave me and it didn't really work. I tried both 2.1 / 2.2 RME.
 
Last edited by a moderator:
Upvote 0 Downvote
Lordfire said:
Yes, create a new database. You can have unlimited databases in a single mySQL server.
Click to expand...


DELIMITER ;
z
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'z' at line 1

This is the error that came up when i tried to upload mysql.sql in the new database.

When I realized what the "z" was and fixed it. i came back to this

DROP TABLE IF EXISTS `houses`;
MySQL said:
#1217 - Cannot delete or update a parent row: a foreign key constraint fails
 
Last edited:
Upvote 0 Downvote
Back
Top