[MySQL] Cannot truncate a table referenced in a foreign key constraint Opcje

[Agape]

Mam problem z tabela tagow w magento, zle sie wgrala i teraz nie moge jej wyczycic:

#1701 - Cannot truncate a table referenced in a foreign key constraint (`mag_us01`.`tag_properties`, CONSTRAINT `FK_TAG_PROPERTIES_TAG_ID_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `mag_us01`.`tag` (`tag_id`))

nie moge wyczyscic tej bazy, probowalem

SET FOREIGN_KEY_CHECKS=0;

ale nic nie dalo ...

[rad11]

W ten sposób?

[SQL] pobierz, plaintext 
SET FOREIGN_KEY_CHECKS=0;
TRUNCATE table1;
TRUNCATE table2;
SET FOREIGN_KEY_CHECKS=1;
[SQL] pobierz, plaintext