Your question isn’t very clear. If you have created your site on your local machine, incl posts, pages, plugins, general settings and you want to recreate it completely as it stands then yes you need to take a mysql_dump of the DB via something like phpMyAdmin, to upload to your production DB but you’ll need to hack some fields in the DB for things like site url, simpler perhaps is to start afresh with a new DB then start re-configuring basic settings and use the WP xml import/export facility to transfer any posts/pages/comments you have locally that you want live.
