clear database

  • Resolved squeebo

    (@squeebo)


    4 years, 12 months ago

    Can you provide a way to clear the database? the blc tables have reached 6MB in size and I’d like to clear them out for the purpose of optimizing the db and keeping smaller backups. I only enable and use this plugin once every 6 months.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Dimitris – WPMU DEV Support

    (@wpmudev-support6)

    Hello @squeebo

    Not sure what you mean by clearing the database, if you want to wipe out relevant records/tables then you should look for:

    1. a blc_installation_log record in the {db_prefix}_options table

    2. the following tables:
    wp_blc_filters
    wp_blc_instances
    wp_blc_links
    wp_blc_synch

    Warm regards,
    Dimitris

    Thread Starter squeebo

    (@squeebo)

    Would that wipe out the plugin settings and/or break the plugin? I just want to wipe out the broken link records that are taking up so much space, since they aren’t needed and I’ll just have it regenerate the list in a few months when I use it again.

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @squeebo ,

    Those tables are not holding the options for the plugin, so when you remove records from them plugin will still have options.
    Before removing any data from the DB you should have a backup of DB, just in case something goes wrong.

    kind regards,
    Kasia

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘clear database’ is closed to new replies.