# dump
mysqldump -p -u $user $db > $db.sql

# dump with prefix (https://stackoverflow.com/a/26514699/6114451)
mysqldump -p -u $user $db $(mysql -p -u $user -D $db -Bse "show tables like '$prefix%'") > $prefix.sql
# with date
$(date +"%Y%m%d_%H%M")

# restore
mysql -p -u $user $db < $db.sql
wp db import $db.sql

# wp search-replace
wp search-replace "$search" "$replace" --recurse-objects --all-tables --dry-run --export=db.sql
# with date
--export="db$(date +"%Y%m%d_%H%M").sql"


# Unicode Fuckups
# set locale pre-export/import to circumvent
export LANG=de_DE.UTF-8
export LC_ALL=de_DE.UTF-8
# Links
https://www.ecosia.org/search?q=mysql%20restore%20db%20unicode
https://makandracards.com/makandra/595-dumping-and-importing-from-to-mysql-in-an-utf-8-safe-way