And when I need to restore, I do a search replace in the sql file all
localhost to that dns…
Doing a find/replace in a text dump of the database will break the serialized data stored in theme options.
Use interconnectit.com WordPress Serialized PHP Search Replace Tool to correctly find/replace serialized data. Some simple themes without options don’t serialize data, and a find/replace in a text dump is OK; but many themes will break.