Skip to main content

MySQL

Export & import database with privileges from .env​

set -o allexport; source /srv/www/cms.skanevux.stagespace.se/shared/.env; set +o allexport
mysqldump -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} > /tmp/sql-dump.sql
set -o allexport; source /srv/www/cms.skanevux.se/shared/.env; set +o allexport
mysql -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} < /tmp/sql-dump.sql

With wp search-replace and dump​

set -o allexport; source /srv/www/cms.hoorihop.hoor.se/shared/.env; set +o allexport
mysqldump -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} > /tmp/sql-dump.sql
set -o allexport; source /srv/www/cms.intranet.hoor.stagespace.se/shared/.env; set +o allexport
mysqldump -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} > /tmp/sql-dump-original.sql
mysql -u${DB_USER} -p${DB_PASSWORD} ${DB_NAME} < /tmp/sql-dump.sql

cd /srv/www/cms.intranet.hoor.stagespace.se/current && sudo -uweb -H wp search-replace https://cms.hoorihop.hoor.se https://cms.intranet.hoor.stagespace.se --network --all-tables
cd /srv/www/cms.intranet.hoor.stagespace.se/current && sudo -uweb -H wp search-replace cms.hoorihop.hoor.se cms.intranet.hoor.stagespace.se wp_blogs