trying to dump my cms_block and cms_page tables to new working Database. I get the Duplicate Entry for Primary Key ...what is the best way to go about this? when I export tables from old db I have Disable foreign key checks as well.
As far as I understood you just need CMS contents to be migrated.
It is not a good idea to inject data in you DB coming from another installation, you can really break something.
Just remeber the two rules of the Magento Fight Club: Never change the core and never inject your DB ;)
Why don't you use an import/export module like this: https://www.magentocommerce.com/magento-connect/export-import-cms-pages-blocks.html
I think it would be a safer method.
I did not try it, but I think it will fit your needings.