Lae eksporditud andmebaasi fail alla phpmyadminist.

Impordi andmebaas käsurealt

wp db reset
wp db import exporditud-andmebaasi-fail.sql
wp cache flush

Vajadusel muuda andmebaasi urlid või andmebaasi nimi.

wp search-replace https://vana-url.ee http://uus-url.local

load.db.sh

#!/bin/bash
cd "${0%/*}"

vendor/bin/wp db reset
vendor/bin/wp db import DB_IMPORT_FILENAME.sql
vendor/bin/wp cache flush

# Remove Woo data
vendor/bin/wp db query "DELETE FROM wp_woocommerce_order_itemmeta;"
vendor/bin/wp db query "DELETE FROM wp_woocommerce_order_items;"
vendor/bin/wp db query "DELETE FROM wp_comments WHERE comment_type = 'order_note';"
vendor/bin/wp db query "DELETE FROM wp_commentmeta WHERE meta_key = 'is_customer_note';"
vendor/bin/wp db query "DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_order' OR post_type = 'shop_subscription' );"
vendor/bin/wp db query "DELETE FROM wp_postmeta WHERE post_id IN ( SELECT ID FROM wp_posts WHERE post_type = 'shop_subscription' );"
vendor/bin/wp db query "DELETE FROM wp_posts WHERE post_type = 'shop_order' OR post_type = 'shop_subscription';"
vendor/bin/wp db query "TRUNCATE wp_actionscheduler_actions"
vendor/bin/wp db query "TRUNCATE wp_actionscheduler_logs"

# Replace domains
vendor/bin/wp search-replace old-url.ee new-url.local *_site *_blogs wp_postmeta
vendor/bin/wp search-replace https://old-url.ee http://new-url.local

site_urls=$(vendor/bin/wp site list --field=url --archived=0 --deleted=0)

vendor/bin/wp transient delete --all --network

for site_url in $site_urls
do
  vendor/bin/wp transient delete --all --url="$site_url"
done

Salvesta ülalolev skript faili load-db.sql ja jooskuta bash-editoris:

./load-db.sh