From ac93ed4d29dd85409fb4c0cd9c2af266e90777c1 Mon Sep 17 00:00:00 2001 From: Daniel Weipert Date: Sat, 19 Oct 2024 10:04:14 +0200 Subject: initial commit --- CLI/mysql_db.sh | 25 +++++++++++++++++++++++++ 1 file changed, 25 insertions(+) create mode 100644 CLI/mysql_db.sh (limited to 'CLI/mysql_db.sh') diff --git a/CLI/mysql_db.sh b/CLI/mysql_db.sh new file mode 100644 index 0000000..e5acfb3 --- /dev/null +++ b/CLI/mysql_db.sh @@ -0,0 +1,25 @@ +# 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 -- cgit v1.2.3