diff options
Diffstat (limited to 'CLI/mysql_db.sh')
| -rw-r--r-- | CLI/mysql_db.sh | 25 |
1 files changed, 25 insertions, 0 deletions
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 |