[resolved] Database table to big - how can I reduce it? (3 posts)

  1. matthisco
    Posted 3 years ago #

    HI folks,

    Im trying to export the sql from phpmyadmin for a wordpress site.

    Problem is this table wp_1_redirection_logs is over 170mb.

    Is there a way I can make it smaller, or could I delete it all together?

    Thanks in advance

  2. s_ha_dum
    Posted 3 years ago #

    You can export it in pieces. Look near the bottom of the PhpMyAdmin export screen. You will see "Dump X row(s) starting at record # Y". Just pick half your rows at a time, or a third, or whatever it takes to get you under whatever limit you are hitting.

    But, as per http://wordpress.org/support/topic/what-is-the-wp_redirection_logs-table?replies=7 , there should be a button to empty the log.

  3. matthisco
    Posted 3 years ago #

    Brilliant, thanks very much

Topic Closed

This topic has been closed to new replies.

About this Topic