Advertisement:

Author Topic: clear my database tables in phpMyAdmin  (Read 3153 times)

fafabibi

  • Newbie
  • *
  • Posts: 10
clear my database tables in phpMyAdmin
« on: November 24, 2011, 02:22:29 pm »
   
Hi, I want to clear my database tables in phpMyAdmin
and I received to error message

# 1451 Unable to delete or update a parent row: a foreign key constraint fails ('construiapidf / oc_ft_category', CONSTRAINT 'oc_ft_category_ibfk_1' FOREIGN KEY ('fk_i_parent_id') REFERENCES 'oc_ft_category' ('pk_i_id'))

How do I empty my database on my phpMyAdmin

Thank you :)

_CONEJO

  • Administrator
  • Hero Member
  • *****
  • Posts: 4689
Re: clear my database tables in phpMyAdmin
« Reply #1 on: November 24, 2011, 06:30:00 pm »
Hi,

Tables should be deleted in specific order.

try with item_resources, item_description, item_comment, item_stats, category_description, ....

Try to delete them one by one, if it can not be deleted, don't worry, keep trying with other tables, once all possible tables are deleted, repeat the process.

This is because some tables depends on other. For example, t_item_description needs t_item and t_locale , so you can not delete t_item or t_locale first...

fafabibi

  • Newbie
  • *
  • Posts: 10
Re: clear my database tables in phpMyAdmin
« Reply #2 on: November 24, 2011, 06:42:13 pm »
merci
thank you very mutch :)