ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

I need to delete about 20,000 relationships

May 26, 2010 11:41am

Subscribe [2]
  • #1 / May 26, 2010 11:41am

    herbageonion

    57 posts

    Hi,

    I have a huge amount of entries which have an even larger amount of relationships, (my exp_relationships database table has over 33,000 rows).

    I’m deleting all of the entries in my channel and I want to delete most of the relationships these entries created but I’m worried about what might happen if I do.

    Is there any relationships that cannot be deleted, how to I identify these?

  • #2 / May 26, 2010 4:15pm

    Ingmar

    29245 posts

    First thing you should do is make & verify a backup of your database. After that you would simply delete the relationships that you no longer need. It might be a bit of trial and error,  but there should be none that can’t be deleted, no.

  • #3 / May 26, 2010 4:32pm

    herbageonion

    57 posts

    Hey, that worked a charm, thanks for settling my fears.

  • #4 / May 26, 2010 4:41pm

    Ingmar

    29245 posts

    Glad it was an easy one 😊 Let us know if there’s anything else.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases