Search and replace with Phpmyadmin

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

for example   replace google.com with yahoo.com

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

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

How can I do that within phpmyadmin

Thanks!

Rowby
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
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

Commented:
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.

Author

Commented:
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