How do you keep your live and and testing server?

there are quite a few threads on here about this topic … just look at these examples:

Database synchronization between dev/staging and production

I would also recommend you read Mark Jaquith’s post on Local and Dev Tip’s.

Related Posts:

  1. How to: Easily Move a WordPress Install from Development to Production?
  2. Database synchronization between dev/staging and production
  3. Most Flawless Way To Transfer from Dev to Prod [duplicate]
  4. Maintaining synced staging/production WP sites
  5. How do you add pages on a staging server, and then move them over to production
  6. What actions affect files, DB, or both?
  7. Merging WordPress posts from different databases
  8. WordPress Staging Site
  9. Setting up a local copy from a production site
  10. How to clean up the theme for production?
  11. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  12. Organizing Code in your WordPress Theme's functions.php File?
  13. Is there a flowchart for WordPress loading sequence?
  14. How to delete post revisions?
  15. How to display by default only published posts/pages in the admin area?
  16. How do register_sidebar() and get_sidebar() work together?
  17. WP Asking for FTP Credentials with XAMPP Localhost
  18. Change html structure of all img tags in WordPress
  19. Allow guests to save favourite pages?
  20. Editing theme files and access to the Code pages only to super-admin?
  21. Trash bin for categories
  22. WordPress custom post types breaks permalink on theme reinstall
  23. WordPress Delete hook with wp_delete_post function?
  24. Show attribute description when filtering by that attribute
  25. WordPress how to override function adjacent_posts_rel_link_wp_head() in link-template.php the correct way
  26. How to display custom field on homepage
  27. Add custom column to Users admin panel with Types user custom fields?
  28. Add custom taxonomy under the category title
  29. woocommerce Add custom field set like billing fields
  30. How to deal with equal & similar arguments for a function?
  31. Custom post type and body_class: Remove “blog” class
  32. Creating bulk posts with Youtube videos
  33. Auto redirect after session expire, but only for one user
  34. Order By table field comment_status in WordPress > 4.0
  35. Sort custom field by post
  36. is_wp_error() and handling errors
  37. How to create a completely private wordpress with multiple membership levels
  38. Why do posts disappear from admin after upgrading from WP 2.7.1 to 3.0.1?
  39. custom meta box for page default template
  40. How can I add custom meta on signup page and pass along to be used after blog activation?
  41. Thumbnail & Category link aside post
  42. “An automated WordPress update has failed to complete – please attempt the update again now”– But there is no .maintenance file
  43. Custom query, multiple custom keys
  44. How to customize
  45. Determine if action was executed in functions
  46. Get custom classes in WordPress Navigation Menu
  47. is wpdb->replace() already sanitized?
  48. Archive subtitles for different types of archives
  49. Implement a Walker with custom object rather than WordPress database object
  50. How to delete all posts, categories and tags from WordPress database
  51. Remove Save Draft & Preview Buttions.. and also Statius: Draft & Visibility: Public
  52. Display custom post type for specific user
  53. Delete a user from frontend
  54. Wrong category nice name is displayed on archive page
  55. Need help with pagination
  56. Adding tags when creating new post
  57. Custom Content Page
  58. Add Member’s birthdate from Backend and shows it on frontside [closed]
  59. Featured Images for Tags?
  60. Custom Post Type Single Loop Outputting Wrong Post
  61. 404 when Previewing an unsaved draft
  62. Query add html after set amount of posts?
  63. WordPress Post Deletion Issue
  64. Custom field not editable by the user
  65. How do I make mysite.com/comingsoon WordPress to become my main website’s WordPress?
  66. Use a custom page with dynamic content as a user profile page
  67. Invitation link to a site in multisite network does not work?
  68. Add helper text in custom-header section in admin
  69. How to edit content in code view of home page when there is some theme applied?
  70. Can we add an extra button on woocommerce shop page and use it to send the product info including image in a mail?
  71. wordpress redirect error in xampp
  72. Multi line of $wpdb->query just run 1 time and end the loop right after
  73. Automatic Set Category For A Custom Post Type
  74. Permanent Custom Post Type
  75. Custom dropdown search form that allows users to select option B based from Option 1
  76. Associating special meaning with user id 0
  77. Undeletable posts, users or other content
  78. Let user delete comment on front end only
  79. Undefined index: custom_sidebars
  80. Header image doesn’t show up on page
  81. How to get name and email value from a custom form and add it to campaign monitor subscriber list?
  82. Why when accessing some wordpress pages on my localhost setup do i get the localhost default page?
  83. Moving site made easier
  84. Auto Linking Words But Only One Time
  85. Best way to define a database with product codes and back-end support?
  86. Custom Link In WordPress Media “Attachment Details” Upload Screen
  87. “Static” pages within a theme
  88. My Server Doesn’t Allow timthumb; How Can I Remove It?
  89. Custom WordPress SQL Query 4 posts per custom taxonomy
  90. How can I add more code to this?
  91. Remove the ‘Press This’ Tool
  92. Edit the Publish Widget Options
  93. why is the delete option missing from just one category?
  94. show posts under custom post type with same autj
  95. User Query Multiple Orderby Clause
  96. Is there any other ways to replicating changes on live from staging without pushing from git
  97. Same slug for Custom Taxonomy archive and CPT archive – Rewrite rule not working
  98. is therer any wordpress function to retrieve a specific html element from post content
  99. Create a page for each database table entries
  100. I have a website issue I am trying to resolve