Skip to:
Content
Pages
Categories
Search
Top
Bottom

Is it ok to delete wp_user_xx_activity & wp_user_xx_activity_catched

  • Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    Hello,

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

    wp_user_xx_activity

    wp_user_xx_activity_catched

    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.

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    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

    Avatar of John James Jacoby
    John James Jacoby
    Keymaster

    @johnjamesjacoby

    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

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    @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?

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    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

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    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:

    wp_blogs

    wp_users

    wp_usermeta

    wp_site

    wp_sitemeta

    wp_sitecategories

    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!

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    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.

    Avatar of Andy Peatling
    Andy Peatling
    Keymaster

    @apeatling

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

    Avatar of Thebigk
    thebigk
    Participant

    @thebigk

    Andy -

    Thanks a ton :D You rock!

Viewing 13 replies - 1 through 13 (of 13 total)

You must be logged in to reply to this topic.