Prune all likes (queries)

[GliX]

GliX submitted a new resource:

Prune all likes (queries) - An example of SQL-queries to prune all likes.

Description: an example of SQL-queries to prune all likes.

Before you perform any action with the database, don't forget to backup!

Queries are executed sequentially:

DELETE FROM xf_liked_content;

UPDATE xf_user AS u
SET like_count = (
   SELECT COUNT(*)
   FROM xf_liked_content AS lc
   WHERE lc.content_user_id = u.user_id
   GROUP BY lc.content_user_id
);

UPDATE xf_post SET likes = 0, like_users = 0x613a303a7b7d;

Read more about this resource...

 

[TickTackk]

Shouldn't it be TRUNCATE instead of DELETE FROM?

 

[GliX]

Shouldn't it be TRUNCATE instead of DELETE FROM?

Not sure: http://www.codeproject.com/Questions/370759/Difference-between-delete-and-truncate - table lock on big forums is unwanted and DELETE can be reverted via binary logs.

 

[m1ne]

Truncate = faster
Delete = safer (can be rolled back)

 

[Kintaro]

how about sharing queries to pruning all likes left from a specific user?