Skip to:

Is it ok to delete wp_user_xx_activity & wp_user_xx_activity_catched

  • thebigk



    I’ve about 4500 tables created in my database for these:



    My SSH backup is running out of memory while backing up the data. Is it ok to delete these tables? I guess they are meant only for tracking the users, right?

Viewing 13 replies - 1 through 13 (of 13 total)
  • If you are running rc2, then yes remove those tables. There is one combined table now. If you are using rc1, then you still need them.



    I’m running RC1. If I remove them, only the user activity track will be lost – is that right? Or will there be some effect on the overall functionality?

    don’t know

    John James Jacoby


    Your best bet might be to update to WPMU 2.7.1 and RC2/trunk. The upgrade from RC1 to RC2+ will automatically eliminate those tables and trim away some of that access.

    If only dieting in real life was so easy



    @John: I’m in a fix now. I already have 1700 user data. I’m running RC1 with WPMU 2.7.

    I’m not able to backup the database because of timeouts …and upgrading without backup is going to be a HUGE risk :(

    I also found out that backups restored through phpMyadmin don’t work!

    Shall I start repainting my decision to use buddypress? Or is there any ray of hope?

    Phpmyadmin is more likely to be with various time out settings.

    Are you able to dyplicatethw database, or log in using ssh?



    I tried backup using SSH – it timed out (because there are 4500+ rows (almost) ) [ error was something like “Ran out of memory” ]

    Surprizingly, phpmyadmin allowed me to backup the database and also restore it – but when restore was complete – I couldn’t see the old things up there. Duh!

    Right now, I’m trying to setup a test site using the database from my live site. What’d be the procedure to do it?

    I’d start with “mysqldump” then import it after into a new db



    Of course I know how to backup database and restore it. However, the normal database backup does not work for me. I get following error:

    mysqldump: mysqldump: Couldn’t execute ‘show table status like ‘wp\_user\_999\_friends\_activity\_cached”: Out of memory (Needed 2093952 bytes) (5)

    mysqldump: mysqldump: Couldn’t execute ‘show table status like ‘wp\_user\_999\_friends\_activity\_cached”: Out of memory (Needed 2093952 bytes) (5)

    I tried restoring an older version of the backup of live site on my test site setup using XAMPP on my desktop. I get “Fatal Error”


    Fatal Error

    If your blog does not display, please contact the owner of this site.

    If you are the owner of this site please check that MySQL is running properly and all tables are error free.

    Could Not Find Blog!

    Searched for localhost.localdomain/rkn/ in wordpressmu::wp_blogs table. Is that right?

    What do I do now?

    Read the bug report page. Some of the guidelines there may help you figure out what went wrong.

    If you’re still stuck with this message, then check that your database contains the following tables:







    If you suspect a problem please report it to the support forums but you must include the information asked for in the WPMU bug reporting guidelines!



    I tried deleting those tables viz. wp_user_xx_activity & wp_user_xx_activity_catched on my local installation and everything seems to be working fine.

    Can someone please confirm if deleting them from live site won’t cause any problem? I guess only the ‘activity’ part is wiped off; which is ok.

    You are fine to delete them, but user activity streams will be lost.



    Andy –

    Thanks a ton :D You rock!

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Is it ok to delete wp_user_xx_activity & wp_user_xx_activity_catched’ is closed to new replies.
Skip to toolbar