I have multiple MySQL databases(50+) and I want to replace a string in all of them, is there anyway to search and replace in all the databases?
Server is CentOS and I have SSH root access.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Instead, you could do something like
SELECT CONCAT("UPDATE ", table_schema, ".", table_name, " SET foo = replace(foo, 'this', 'that');") FROM information_schema.tables WHERE ...
to generate the desired 50+
UPDATE statements. Then copy and paste them into the mysql commandline tool.
(Or you could construct a shell script using that. Or...)