I couldn’t import the data back to my website with the all in one wp plugin, the import just did not work (got stuck at 2% and the advanced feature ftp etc were not available).

WP Migrate DB worked for me but I prefer doing it manually anyway. Now that I’ve identified I was missing some path I’ve just updated my “cleanup” sed command.

Thanks for the help anyway.