place a sql file like zz_find_replace.sql into the folder init close to your docker-composer file the can look like UPDATE wp_options SET option_value = replace(option_value, 'http://foo.live', 'http://127.0.0.1:8103') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'http://foo.live','http://127.0.0.1:8103'); UPDATE wp_posts SET post_content = replace(post_content, 'http://foo.live', 'http://127.0.0.1:8103'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://foo.live', 'http://127.0.0.1:8103'); Initializing a fresh instance When a container is started for the first time, a new database with the specified name will be created and initialized with the provided configuration variables. Furthermore, it will execute files with extensions .sh, .sql and .sql.gz that are found in /docker-entrypoint-initdb.d. Files will be executed in alphabetical order. You can easily populate your mariadb services by mounting a SQL dump into that directory and provide custom images with contributed data. SQL files will be imported by default to the database specified by the MYSQL_DATABASE variable.

https://hub.docker.com/_/mariadb/

UPDATE wp_options SET option_value = replace(option_value, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com/') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'https://testhost1:8890','https://promatix2021.bueroloewenherz.com/'); UPDATE wp_posts SET post_content = replace(post_content, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com/'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com/'); 14.10.17 UPDATE wp_options SET option_value = replace(option_value, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp_posts SET guid = replace(guid, 'https://testhost1:8890','https://promatix2021.bueroloewenherz.com'); UPDATE wp_posts SET post_content = replace(post_content, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com'); UPDATE wp_postmeta SET meta_value = replace(meta_value, 'https://testhost1:8890', 'https://promatix2021.bueroloewenherz.com'); 14.10.17 sed -i 's/https:\/\/shock.se/http:\/\/127.0.0.1/g' shocksesql1.sql mysqldump mydatabase > db.sql sed -i 's/stringtofind/stringtoreplace/g' db.sql mysql mydatabase < db.sql 14.10.17

https://tonyteaches.tech/how-to-do-a-mysql-find-and-replace-on-the-entire-database/

UPDATE wp9735options SET option_value = replace(option_value, 'https://se.shock.local', 'https://ww1.shock.se') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp9735posts SET guid = replace(guid, 'https://se.shock.local','https://ww1.shock.se'); UPDATE wp9735posts SET post_content = replace(post_content, 'https://se.shock.local', 'https://ww1.shock.se'); UPDATE wp9735postmeta SET meta_value = replace(meta_value, 'https://se.shock.local', 'https://ww1.shock.se'); 14.10.17 UPDATE wp9735options SET option_value = replace(option_value, 'https://se.shock.local', 'https://ww1.shock.se') WHERE option_name = 'home' OR option_name = 'siteurl'; UPDATE wp9735posts SET guid = replace(guid, 'https://se.shock.local','https://ww1.shock.se'); UPDATE wp9735posts SET post_content = replace(post_content, 'https://se.shock.local', 'https://ww1.shock.se'); UPDATE wp9735postmeta SET meta_value = replace(meta_value, 'https://se.shock.local', 'https://ww1.shock.se'); 14.10.17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024