Restoring wordpress site from backup

In theory should be straightforward: mySQL database + files restore.

In practice not so easy. Here are some trouble you may jump into

Website domain changes

It happens that before restoring the backup you want to play with some values in the sql dump - for example if the domain name changed.

(278, 'oxygen_theme_settings', 'a:1:{s:13:"footer_insert";s:258:"
(2, 'home', 'http://chatzone.tv', 'yes'),

And test your site's restoration. Do the rest within wordpress webpage admin.