string replace in the whole database

This is an open forum for any mojoPortal topics that don't fall into the other categories.

This thread is closed to new posts. You must sign in to post in the forums.
11/3/2013 4:51:29 AM
Gravatar
Total Posts 220

string replace in the whole database

Hello,

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 smiley

Best
Matthias

You must sign in to post in the forums. This thread is closed to new posts.