SQL Foreign Key Constraint Error 1025 (152)

mysql sql mysql-error-1025
Xavier picture Xavier · Mar 17, 2011 · Viewed 7.8k times · Source

I keep getting an error every time i try to drop a table called "countires" and a field called "countries".

#1025 - Error on rename of '.\mutli_page_form\survey'
to '.\mutli_page_form\#sql2-820-1fb' (errno: 152)

It says there is a FK dependency on the table "survey" i have tried multiple times to delete it to no success.

#1217 - Cannot delete or update a parent row: a foreign key constraint fails

I now get this error once trying to delete the table of Countries

Answer

Jay picture Jay · Mar 17, 2011

The database has been told to ensure data integrity. This is what you're seeing. There is survey data that references a country. If you delete the country table then the survey data won't have valid countries associated with it. You'll have to remove the surveys first before you can remove the countries.

Related questions

#1025 - Error on rename of './database/#sql-2e0f_1254ba7' to './database/table' (errno: 150)

So I am trying to add a primary key to one of the tables in my database. Right now it has a primary key like this: PRIMARY KEY (user_id, round_number) Where user_id is a foreign key. I …

Read More
Renaming foreign-key columns in MySQL

We're trying to rename a column in MySQL (5.1.31, InnoDB) that is a foreign key to another table. At first, we tried to use Django-South, but came up against a known issue: http://south.aeracode.org/ticket/243 OperationalError: (1025, "Error on rename …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More