Error Importing SQL Database

[MauroSicard]

Hi there!

I'm trying to import the schemas/mysql.sql into the database on PHPMyAdmin, but it gives me this error:

Could someone please tell me how to fix this?

Or, could someone please add me on Discord on Skype to help me? I would be very glad to be able to chat with some of you who are really experienced.

Thank you,
Mauro Sicard

 

[mackerel]

Hi there!

I'm trying to import the schemas/mysql.sql into the database on PHPMyAdmin, but it gives me this error:

Could someone please tell me how to fix this?

Or, could someone please add me on Discord on Skype to help me? I would be very glad to be able to chat with some of you who are really experienced.

Thank you,
Mauro Sicard

You mean you want to import only part of the database or the entire database? If the latter, there is no need to have all the tables in tibiazero database like you have now. What is happening is the query is trying to remove houses table but it cannot do it because there are probably references to another table

 

[MauroSicard]

@mackerel Can I add you on Skype? I need a little more help

 

[mackerel]

@mackerel Can I add you on Skype? I need a little more help

I would prefer discord but anyway, not gonna happen anytime soon

 

[samco]

Show here your houses table structure, we need to check foreigns keys