I developed a template on my local server, and now I'd like to download the content of my WordPress blog on my shared hosting to my local server so I can try it out with my template.
When I simply download the whole database it will break up my whole design and some of the links will lead me to the domain of my actual blog on the shared hosting.
If I simply download the posts table it won't work properly either.
So I'd like to know which exact tables do I need and what would be the best way to create a 1:1 copy of my shared hosting blog to my local server but with the new template on the local server?