string replace in the whole database
yesterday I had to laugh about how easy it can be.
An existing mojo website should move to another domain.
There were 184 absolute links to specific events in the Event Calendar Pro, all of which began with "www.charlottenburger-kiez.de". This had to be replaced by "www.spiegelsalon.de".
I searched Google for "sql mysql replace whole database" and read a lot before I finally found a very short answer:
export sql dump, search and replace, import sql dump.
I exported the database using "phpMyAdmin" into a text file (text.sql), carried out the substitutions with a single command and imported the file back into the database.
It worked great and all in all it took maybe 5 minutes