Moving MySQL databases between hosts and domains

If you have ever moved a WordPress site from one domain to another, you have inevitably come across the problem where the old URLs are now broken and will need to be updated. When you have websites with databases over 90MB, this could be a daunting experience. Luckily Search Replace DB has saved my behind every time!