wp_bksh_backups
StaticStores bksh backups data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| backup_id | VARCHAR(36) | NO |
| label | VARCHAR(255) | NO |
| type | VARCHAR(20) | NO |
| status | VARCHAR(20) | NO |
| size | BIGINT(20) | NO |
| file_path | TEXT | YES |
| storage | VARCHAR(50) | NO |
| storage_path | TEXT | YES |
| includes | LONGTEXT | YES |
| site_url | VARCHAR(255) | YES |
| wp_version | VARCHAR(20) | YES |
| php_version | VARCHAR(20) | YES |
| db_version | VARCHAR(20) | YES |
| notes | TEXT | YES |
| log | LONGTEXT | YES |
| created_at | DATETIME | NO |
| started_at | DATETIME | YES |
| completed_at | DATETIME | YES |
| duration_secs | INT UNSIGNED | YES |
| name | VARCHAR(100) | NO |
| type | VARCHAR(20) | NO |
| frequency | VARCHAR(20) | NO |
| time_of_day | TIME | NO |
| day_of_week | TINYINT(1) | YES |
| day_of_month | TINYINT(2) | YES |
| storage | VARCHAR(50) | NO |
| retention | INT(3) | NO |
| active | TINYINT(1) | NO |
| last_run | DATETIME | YES |
| next_run | DATETIME | YES |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_bksh_backups ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, backup_id VARCHAR(36) NOT NULL, label VARCHAR(255) NOT NULL DEFAULT '', type VARCHAR(20) NOT NULL DEFAULT 'full', status VARCHAR(20) NOT NULL DEFAULT 'pending', size BIGINT(20) NOT NULL DEFAULT 0, file_path TEXT, storage VARCHAR(50) NOT NULL DEFAULT 'local', storage_path TEXT, includes LONGTEXT, site_url VARCHAR(255), wp_version VARCHAR(20), php_version VARCHAR(20), db_version VARCHAR(20), notes TEXT, log LONGTEXT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, started_at DATETIME, completed_at DATETIME, duration_secs INT UNSIGNED, PRIMARY KEY (id), UNIQUE KEY backup_id (backup_id) ) $charset;"; $sql2 = "CREATE TABLE IF NOT EXISTS wp_bksh_schedules ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(100) NOT NULL, type VARCHAR(20) NOT NULL DEFAULT 'full', frequency VARCHAR(20) NOT NULL DEFAULT 'daily', time_of_day TIME NOT NULL DEFAULT '02:00:00', day_of_week TINYINT(1), day_of_month TINYINT(2), storage VARCHAR(50) NOT NULL DEFAULT 'local', retention INT(3) NOT NULL DEFAULT 7, active TINYINT(1) NOT NULL DEFAULT 1, last_run DATETIME, next_run DATETIME, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;"; // Direct table creation for maximum reliability (avoiding dbDelta issues on some hosts) // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.SchemaChange -- Schema creation in activation hook // phpcs:disable WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange -- activation hook table creation $wpdb->query( $sql1 );
Safe to delete?
If you have uninstalled BackShift — Backup & Migration, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_bksh_backups`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from BackShift — Backup & Migration