I am running Drupal 6 and Ubercart 2. I run a development server locally on my computer which I use to make changes to the site, which is hosted with traditional web hosting.
In the past I have made my changes locally and then just re-uploaded all the files and the database when I wanted to push a newer version of my site.
The "problem" is that I have now received some orders on the hosted website, so I have user accounts and order history that I cannot just overwrite.
How do I move everything from my local development server to the hosted website without overwriting and deleting the user accounts and order history. Alternatively, how can I move all the user account and order history data over to my local development server before I move/overwrite?
I could go into phpmyadmin and move over the tables for the users/orders, but I do not know if this will have ramifications elsewhere.