mysqldump --user=root --password=uLtRaSeCrEt12345 --default-character-set=utf8 --tz-utc --set-gtid-purged=OFF wpdbname > wpdbname.sql
#!/bin/sh
/usr/bin/sed -e "s/https:\/\/obsigna.net/https:\/\/localhost\/blog.obsigna.net/g" -i "" /path/to/wpdbname.sql
/usr/bin/sed -e "s/%2Fobsigna.net/%2Flocalhost%2Fblog.obsigna.net/g" -i "" /path/to/wpdbname.sql
echo "drop database wpdbname; create database wpdbname;" | mysql --user=root --password=uLtRaSeCrEt12345 --default-character-set=utf8
mysql --user=root --password=uLtRaSeCrEt12345 --default-character-set=utf8 wpdbname < /path/to/wpdbname.sql
Cname site 1 to site 2, make sure all users same.I want to be able to keep an Internet Wordpress site synced up with a local site.
Is anyone aware of any guides on how to do this?
Both sites will be running on FreeBSD.
Cname site 1 to site 2, make sure all users same.
Have 1 wordpress and point both DNS names to it.Thanks for the advice, but I don't understand what you mean.