Search and replace with Phpmyadmin

Rowby Goren
Rowby Goren used Ask the Experts™
Hi I need to use phpmyadmin to replace one doman name with another

for example   replace with

There are no http;// involved -- just the doman name as in this format

I want to replace it in the entire database.  All tables.

How can I do that within phpmyadmin


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use the backup/dump function, get it to you locally, so you can use notepad++ (or similar) to do a text replace. After that, restore/upload the dataabase.
David FavorFractional CTO
Distinguished Expert 2018

Best keep in mind many CMS systems like WordPress use serialized data.

A sure way to destroy your site is to do a search + replace using phpMyAdmin.

If you have any serialized data in your database, you must use a serialized data away tool...

For example, wp-cli for WordPress or some standalone script that handles serialized data.

Big Tip: If you do a phpMyAdmin search + replace which modifies any serialized data, you will likely have to hire someone to attempt recovering your data, which will be a long + costly process.


THanks to both.  I hope I awarded the points correctly using the new interface????   I want to split them if still possible??

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial