'MySQL Update Command for WordPress DataBase

I've a WordPress DB on a "POC" site (Proof of concept) On this DB, I've some strings that are specific to this site :

  • URL = poc.test.com
  • Path = /home/user/sites/poc

I want to copy this DB on the prod DB where this strings change:

  • URL = test.com
  • Path = /home/user/public_html

How I can update all tables (users, post, post_meta, ...) with mysql update command?

Table names may vary depending on the site

mysqlwordpresssql-update


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

MySQL - How do I enter NULL?

MySQL - How do I enter NULL?

MySQL - How do I enter NULL?

mysql update query throwing syntax error

UPDATE Query without WHERE Clause

Why is my SQL UPDATE syntax giving 'ambiguous column name'?

How to update record with the same data of existing record

How to execute multiple update queries using jooq execute or batch execute without code generation?

SQLAlchemy update multiple rows in one transaction

Remove duplicate entries from string array column of postgres

SQL query - How to increase the salary of employees, without exceeding a certain salary limit

PostgreSQL duplicate key value violates unique constraint while using on conflict do nothing on insert

Using 'on conflict' with a unique constraint on a table partitioned by date

Using 'on conflict' with a unique constraint on a table partitioned by date

SQLite impute missing values by mean for every group