Ways of managing staging and production wordpress sites?

The problem seems to be you not deciding what is the “staging” server for. If it is for content staging/creation than it is actually a production server from software development POV. Anything that assumes that the software is functioning well and results in something being actually published is part of the production system.

You need a different server for software development needs. With two distinct server your problem becomes a simple communication and planning problem.

Good communication can also help in using the same server, but it is easier to be able to have two separate ones when you both need access to “staging” functionality.

Related Posts:

  1. Database synchronization between dev/staging and production
  2. What actions affect files, DB, or both?
  3. Staging sites, how do you manage synchronising updates in the DB?
  4. Merging WordPress posts from different databases
  5. Difficulty importing my live site to local
  6. Localhost to Staging to Development Dynamic WP-CONFIG
  7. Setup 3 Sites To Connect To 1 Database and Share Data
  8. Changing between Local Host DB to Production DB and in reverse
  9. Database migration issues – Error #1046 No database selected
  10. Export and import, only new and updated WordPress data
  11. What is an ORM, how does it work, and how should I use one? [closed]
  12. What is the difference between an ORM and an ODM?
  13. What is this JavaScript “require”?
  14. Rename a table in MySQL
  15. How should I tackle –secure-file-priv in MySQL?
  16. What is this JavaScript “require”?
  17. What is “Advanced” SQL?
  18. What’s the difference between identifying and non-identifying relationships?
  19. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  20. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  21. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  22. What are the differences between B trees and B+ trees?
  23. MySQL SELECT increment counter
  24. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  25. Example of a strong and weak entity types
  26. Oracle SQL query for Date format
  27. phpMyAdmin – Error > Incorrect format parameter?
  28. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  29. Difference between partition key, composite key and clustering key in Cassandra?
  30. How SID is different from Service name in Oracle tnsnames.ora
  31. What is a relation in database terminology?
  32. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  33. Database vs File system storage
  34. Can I have multiple primary keys in a single table?
  35. Exclude Statement in SQL
  36. How do you query for “is not null” in Mongo?
  37. What is a file based database?
  38. Is it fine to have foreign key as primary key?
  39. Storing Images in DB – Yea or Nay?
  40. How to: Easily Move a WordPress Install from Development to Production?
  41. Using wpdb to connect to a separate database
  42. how to Optimize WordPress database for 10 million post? [duplicate]
  43. MySQL Database User: Which Privileges are needed?
  44. Why is my database import losing text widget data?
  45. Keeping WP database synced across multiple developers using git
  46. WPDB Insert or if exists Update
  47. Multiple developers / editors working on a site in progress
  48. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  49. WordPress database synch between dev and prod
  50. get_results using wpdb
  51. Will it break my site if I delete all transient records in wp_options table?
  52. Checking if Database Table exists
  53. Why WordPress choose data serialization over json_encode?
  54. What’s the simplest way to backup my WordPress database?
  55. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  56. $wpdb won’t insert NULL into table column
  57. Relaunch 4.2 utf8mb4 database upgrade
  58. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  59. Safest way to bulk delete post revisions
  60. Please explain how WordPress works with MySQL character set and collation at a low level
  61. DB connection error after copying a WordPress Multisite instance to a second location
  62. Solution for database version control and deployment?
  63. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  64. How many users can WordPress handle?
  65. Get error messages when $wpdb->insert() returns false?
  66. Detecting errors generated by $wpdb->get_results()
  67. Does dbDelta delete columns as well?
  68. How to get the post publish date outside the loop?
  69. MariaDB as a backend database
  70. wpdb update add current timestamp not working
  71. Site stuck in “Database Update Required” loop
  72. How to fetch Data in WordPress using MySQLi or $wpdb
  73. WordPress Database lost auto increment
  74. Count & Display Database Queries
  75. Connect to database using wordpress wp-config file
  76. How can I make a WordPress database portable and url independent?
  77. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  78. wpdb->insert multiple record at once
  79. How to migrate a HTTPS WordPress installation to localhost?
  80. Two WordPress sites sharing the same content
  81. How to integrate custom database table in WordPress and using WordPress functions
  82. Reset Post IDs to less than 64bit integer
  83. WP Multisite: load content from site X on site Y
  84. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  85. Custom form that store input in database
  86. Restoring WordPress posts from database only
  87. What is the purpose of the option name hack_file in the options table?
  88. Where can I find the database changes between WordPress versions?
  89. Automate WordPress Database Upgrade
  90. Database connection close
  91. WordPress database error with latest WP – “WP_termmeta doesn’t exist”
  92. WordPress database scalability from the code perspective
  93. WordPress Unit Testing – Cannot Create Tables
  94. Using transients in conjunction with memcached
  95. Displaying content from one WP site on separate WP site
  96. Lost the `wp_options` table: what’s the best way to restore the site?
  97. How to define composite keys with dbDelta()
  98. Insert data in database using form
  99. Is sanitize_text_field() is enough to save to DB?
  100. Does wpdb add considerable overhead on queries with large result sets?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)