blob: e5acfb3f70409ad2244ca5a97dfbe6d28da5e729 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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
|
