I have a live WordPress blog that is currently linked from my html website (created with Dreamweaver).
I would like to create my entire website from WordPress instead, but I don't want to lose all the information from my current blog. I'm trying to replicate what I have, but edit static pages, etc., offline without affecting my current online blog.
I copied all the files using ftp, so the structure isn't the problem. What is the problem is that I can't figure out how to copy the SQL database itself. When I copy it to a new database (say blog2), I can't access it online. It reverts back to the original blog.
How do I get around this?