Thanks…It worked though I was making a mistake and was accessing phpmyadmin on my localhost with a wrong user name. It should always be root. And so I could export a sql file and uploaded it in my shared host server and made changes to Wp_options to point to my url instead of localhost.
