Thanks for all the support. i started by
1. Deactivating all of the plug-ins at old site.
Than after a variety of approaches towards transferring my website to a different outside server,
2. I used myPHPadmin to export/import just the wp-(comments, links, options, postmeta, post terms, term_relationships & taxonomy, usermeta, and user) tables from my old WordPress database.
3.I than used the search and replace tool mention above (PHP Search|Replace Tool) on each of the tables.
4. Activated my plug-ins on the new site location; I am good to go!
Thanks again for all your support!!!!!
