Moving minor updates between local and live sites – just database?

If you only changed some CSS, then updating the CSS file on the live server should be sufficient (unless you need to clear a cache or something).

If you changed/created posts on your localhost – then those posts will not be on your live site. You could overwrite the live site’s database with your localhost database – however then you will lose any data that was created on the live site (for example, comments).

In general, if the posts/pages you’re creating on localhost are supposed to also be on the live site, you’re better off creating them there in the first place.

Related Posts:

  1. Problem migrating to localhost
  2. How to transfer from localHost to live but use the already existing database on the server?
  3. Database migration issues – Error #1046 No database selected
  4. Restoring .sql backup results in “Error establishing a database connection”
  5. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  6. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  7. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  8. Multiple developers / editors working on a site in progress
  9. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  10. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  11. Solution for database version control and deployment?
  12. How to migrate a HTTPS WordPress installation to localhost?
  13. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  14. Migrating data between local and development server
  15. Best way to import users, post and categories from an external database
  16. Syncing local content with development / staging sites
  17. Organizing WP Pages based on old website database
  18. Presentation vs Content in WP DB-Tables
  19. Connect to remote database using Localhost install
  20. Best way to move live site local
  21. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  22. Migrate a Non WordPress database to wordpress [closed]
  23. Connect to live db whilst working locally
  24. Weird issue with database migration and SSL links
  25. How to fix unchanged URLs in Database after running serialized search and replace script?
  26. Migrating database / content of non-CMS site to WordPress
  27. How do I reset a self-hosted WordPress URL?
  28. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  29. Export all content from wordpress
  30. Import live site to local setup without access to live site
  31. Moving online website to MAMP or dumb idea?
  32. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  33. Connect to a remote database for wordpress in my own hosting server
  34. Difficulty importing my live site to local
  35. How to move the WordPress site Layout from test site to Production site?
  36. Merging two databases without borking it
  37. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  38. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  39. Trouble Migrating all data blog from WordPress.com to WordPress.org
  40. Copying database tables to new database
  41. Migrating from PDO using SQLite to clean new install using MySQL
  42. Migration: Copying database content to a different server
  43. Change WordPress URL in sql file via Terminal
  44. Strange characters added to the database
  45. After database migration, theme mods don’t show [closed]
  46. WordPress url transformation script
  47. Design problems when exporting remote database for local development
  48. Image link issues after importing a database backup to my local web server
  49. Installing local to live WP into subdirectory
  50. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  51. Cloning blog to localhost via WAMP
  52. echo site_url() returns a different value than what is in the database siteurl field
  53. Recovery – Restore Database after moving folder location locally
  54. Migrate Users From laravel to wordpress
  55. /wp-admin not accessible after migrating to local host (no plugin issue)
  56. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  57. How to fix Uploaded to this post option to see group of images uploaded to a post?
  58. How do you enable scripts on a WordPress installation in Softaculous?
  59. WordPress site migration – locked out of admin area
  60. Malware in old website – how to migrate?
  61. WP website showing blank page after moving from subdomain to main domain
  62. WordPress Migration – Issue with admin panel changes
  63. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  64. Search and Replace in Windows XAMPP site
  65. How to edit posts/pages without making the change live?
  66. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  67. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  68. Cloned site not connecting to database – MAMP
  69. Locally installing wordpress. Database problem
  70. I cannot change anything in my wordpress database from within wordpress?
  71. Local Content different from Remote Content
  72. Media library images “missing” after migrating them using SQL
  73. How can I work on a database along side a client?
  74. import (migration) user database to wp-users
  75. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  76. Moving database from WP 2.6 to 3.5 problem
  77. Importing Concrete5 content to WordPress
  78. Theme Options – localhost to new url
  79. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  80. Can I connect WordPress website with an external database?
  81. Restoring WordPress posts from database only
  82. storing database in version control
  83. Sub-domain or 2nd, temporary different domain?
  84. How do i get user data from a custom table in the wordpress database by user ID?
  85. Converting WordPress into Android or iPhone app
  86. WordPress returns to an old version
  87. Super slow queries from author archive pages killing my database
  88. Best practice to limit results in get_row()?
  89. Which table (and column) has the content of configured get_post_meta?
  90. Serialize data before inserting into the DB
  91. Pages from custom table
  92. How to display data from db in select list [closed]
  93. Native timestamp on wp_options option
  94. Page not found after migration to localhost. I already updated the sql links and the permalinks. Wp-admin page works perfectly
  95. SELECT rows between two datetimes when the range is dynamic [closed]
  96. error establishing a database connection 3
  97. Correct and secure way to access a custom SQL database in a custom PHP template file
  98. Custom metabox does not store data
  99. Local host to server import problem
  100. featured image not showing up with mysql_connect