![]() ![]() Look for rows with a "post_type" value of "attachment." These are media files.Click on the "wp_posts" table to open it.Log into phpMyAdmin and select your WordPress database from the list of databases.To delete inactive WordPress plugins completely, we suggest you follow our latest step-by-step guide. To delete inactive WordPress themes and plugins, run the following SQL commands in phpMyAdmin:ĭELETE FROM wp_options WHERE option_name LIKE 'template_%' OR option_name LIKE 'stylesheet_%' ĭELETE FROM wp_options WHERE option_name = 'active_plugins' Īlternatively, log in to your WordPress dashboard and select the "Appearance" or “Plugins” options for inactive themes and plugins, respectively.įrom there, you can select and delete them (in the example below, we’re deleting an inactive WordPress theme). This includes unused themes and plugins, media files, posts and pages, and tags. Unused data can accumulate over time, leading to a cluttered database. To optimize tables, select them from the list on the left in phpMyAdmin, and check the box next to them.įrom the "With selected" drop-down menu, select "Optimize table." Click on the "Go" button to start the optimization process. Tables with a high amount of overhead may need optimization. Identify tables with overhead: Overhead is the amount of space in a table that is used but not required.Check for tables with large sizes: Tables, such as the wp_options and wp_postmeta tables, may benefit from optimization to improve website performance.Look for tables that are frequently updated: Tables, such as the posts, comments, and user meta tables, are good candidates for optimization.Here are some tips on how to identify the tables that need optimization: In general, you can optimize all database tables, but some may require more attention than others. If you don’t feel confident running the command line, we recommend you go with any of the tried-and-tested plugins. Note: Manual WordPress database cleanup requires some technical knowledge. Change it to match the ones used by your database. Please note all SQL commands shared below use the standard “wp_” prefix. To access the phpMyAdmin interface, log in from your web hosting control panel or through a plugin like WP phpMyAdmin. Generally, the manual approach requires access to your WordPress dashboard and phpMyAdmin – a web-based application for managing MySQL databases. It's important to save the backup in a secure location (like a Cloud space) so you can restore your website easily. To create a backup, you can use a plugin or access cPanel and use the built-in backup tool. This ensures you have a copy of your website's data in case anything goes wrong during the cleanup process. Maintaining a clean WordPress database is an effective step not only toward better website speed and performance but also:Ĩ manual cleanup techniques for a faster WordPress database (via phpMyAdmin)īefore performing any database cleanup, it's essential to perform a backup. Slow down backups and maintenance tasks.As your website grows, your database can become bloated with unnecessary data, which can: ![]() Your WordPress database stores all your website data, including posts, pages, comments, media files, and user information. Why WordPress database cleanup is necessary Tips for Maintaining a clean and fast database.5 best plugins for WordPress database cleanup. ![]() 8 manual cleanup techniques for a faster WordPress database (via phpMyAdmin. ![]()
0 Comments
Leave a Reply. |