Search Regex vs WP-DBManager

Search Regex adds a powerful set of search and replace functions to WordPress posts, pages, custom post types, and other data sources. These go beyond the standard searching capabilities, and allow you to search and replace almost any data stored on your site. In addition to simple searches you have the full power of PHP’s regular expressions at your disposal. You can use this to do things like: – Help migrate a site from one domain to another – Update URLs in links and images – Perform site-wide changes Search filters can be created to match any column of any WordPress table. For example: – Find all posts in a category – Find all post meta data without a post – Find all posts in a date range Search Regex handles small and large sites. Search Regex has been tested with PHP from 7.4 to 8.4. What can I search? You can search: – Posts – Pages – Any custom post type – Comments (including spam) – Users – Meta data – WordPress options Full regular expression support is provided, and you can capture data and use it in the replacement. Actions A variety of actions can be performed on matching results: – Modify and replace the result – Delete the result – Export to CSV and SQL – Perform custom PHP action Modify and Replace Data Results can be individually modified by clicking on the item to change, and using the popup modifier. Bulk modifications can be performed against all matching results. The types of modification depend on the data being changed: – Numbers can be added or subtracted to existing numbers – Hours, days, weeks, and months, can be added to dates – Tags and categories can be added, removed, and substitued Custom shortcodes are supported that allow dynamic data to be included: – Add the current date and time, in any format, to content – Insert data from other columns. For example, insert the category into the title – Transform existing data. For example, convert case, change underscores to dashes. Example uses Some ideas for potential uses: – Delete all comments that match a phrase – Add a category to all matching posts – Remove orphaned meta data Support Please submit bugs, patches, and feature requests to: https://github.com/johngodley/search-regex Please submit translations to: https://translate.wordpress.org/projects/wp-plugins/search-regex Translations Translations are provided by WordPress itself. You can update the translations by going to the Dashboard > Updates section of WP admin. Documentation Full documentation can be found on the Search Regex site.

Allows you to optimize database, repair database, backup database, restore database, delete backup database , drop/empty tables and run selected queries. Supports automatic scheduling of backing up, optimizing and repairing of database. General Usage Activate WP-DBManager Plugin The script will automatically create a folder called backup-db in the wp-content folder if that folder is writable. If it is not created, please create the folder and ensure that the folder is writable Open Folder: wp-content/backup-db If you are on Apache, move the htaccess.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/.htaccess if it is not there already If you are on IIS, move the Web.config.txt file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/Web.config if it is not there already Move index.php file from Folder: wp-content/plugins/wp-dbmanager to Folder: wp-content/backup-db/index.php if it is not there already Go to WP-Admin -> Database -> DB Options to configure the database options Build Status Development https://github.com/lesterchan/wp-dbmanager Translations http://dev.wp-plugins.org/browser/wp-dbmanager/i18n/ Credits Plugin icon by Freepik from Flaticon Donations I spent most of my free time creating, updating, maintaining and supporting these plugins, if you really love my plugins and could spare me a couple of bucks, I will really appreciate it. If not feel free to use it without any obligations. Disclaimer Note that this plugin passes your datababase password via –password in the command line of mysqldump. This is convenient but as a trade off, it is insecure. On some systems, your password becomes visible to system status programs such as ps that may be invoked by other users to display command lines. MySQL clients typically overwrite the command-line password argument with zeros during their initialization sequence. However, there is still a brief interval during which the value is visible. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. Source: End-User Guidelines for Password Security If this is a concern to you, I recommend another database backup plugin called WP-DB-Backup To know about the difference between WP-DBManager and WP-DB-backup, checkout What is the difference between WP-DBManager and WP-DB-Backup? in the FAQ section.