Recently I stuck in the middle. I had completed the wordpress theme in wamp(Windows), and now I wanted to move it to cPanel (linux). And the had full path like C:\wamp\www. Now when I uploaded this theme to server, the uploaded version of it was totally distorted.
I tried different approaches to solve this problem like find & replace & many other efforts.
But after all they did not worked for all the problem of path in option table for wordpress database.
Then I found this plugin that makes copy of your database now you need to install this plugin.
Secondly you have to create a backup of your wordpress. Then It will give you a link of zip archive. Now upload that link to your server.
To restore this backup into the Remote Server just give the link like this
And just click the upload you will see the same wordpress will is restored in remote server also.