wpcli regex search - Use Regex with WP CLI to 🔎 Search & Replace in Database

Use Regex with WP CLI to 🔎 Search & Replace in Database

When cleaning websites that have large databases, regular text editors can’t even open the database dumps (Notepad++ supports files up to 2GB in size). So to run a search and replace on large database dumps I suggest using regex-replace line-by-line in PHP, or setting up WPCLI and running regex search & replace. Here is a … Read full article →

wpcli export specific tables wordpress - Dumping specific tables using mysqldump or WP-CLI

Dumping specific tables using mysqldump or WP-CLI

For high-traffic websites, I advise developing a stagging website if you make significant updates or even switch the WordPress theme entirely. But one significant problem I encountered while moving from the staging site to the live one is that all database tables are updated, which could result in financial loss if the website receives multiple … Read full article →

How to Reset WordPress Password from phpMyAdmin Database - How to Reset WordPress Password from phpMyAdmin Database

How to Reset WordPress Password from phpMyAdmin Database

Locked out of your wp-admin area? Forgot the password? No problem, the easiest way to regain access is to reset your admin password from your database via phpMyAdmin. Step 1. Open PHPMyAdmin The first step is to log into your cPanel and under Databases select phpMyAdmin. Step 2. Select your database name From the left … Read full article →