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. What is the difference between XAMPP or WAMP Server & IIS?
  12. How do I use MySQL through XAMPP?
  13. phpMyAdmin access denied for user ‘root’@’localhost’ (using password: NO)
  14. XAMPP Port 80 in use by “Unable to open process” with PID 4
  15. Cannot access to localhost/xampp/index.php
  16. Localhost is not working
  17. localhost/xampp/ or http://localhost/index.php can’t be accessed
  18. How do I run a file on localhost?
  19. Xampp MySQL not starting – “Attempting to start MySQL service…”
  20. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  21. XAMPP Apache won’t start
  22. XAMPP, Apache – Error: Apache shutdown unexpectedly
  23. What is the use of Mercury and Tomcat in Xampp control panel?
  24. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  25. Xampp Access Forbidden php
  26. mysql said: Cannot connect: invalid settings. xampp
  27. How to solve “Error: MySQL shutdown unexpectedly”?
  28. XAMPP installation on Win 8.1 with UAC Warning
  29. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  30. How do I find what causes a blank white screen in WordPress?
  31. WordPress on XAMPP setting up Zoho mail
  32. Why should define(‘RELOCATE’,true) be removed from wordpress config?
  33. Best collection of code for your 'functions.php' file [closed]
  34. Is moving wp-config outside the web root really beneficial?
  35. Hide the fact a site is using WordPress?
  36. Objective Best Practices for Plugin Development? [closed]
  37. Organizing Code in your WordPress Theme's functions.php File?
  38. What does this PHP function code mean? [closed]
  39. similar of my posts in all over the internet sites and blogs [closed]
  40. When to use is_home() vs is_front_page()?
  41. Is there a flowchart for WordPress loading sequence?
  42. How to change the default registration email ? (plugin and/or non-plugin)
  43. Best collection of code for your .htaccess file [closed]
  44. MySQL Database User: Which Privileges are needed?
  45. Essential technical features for high-end WordPress web hosting? [closed]
  46. How to structure a plugin
  47. How to remove admin menu pages inserted by plugins?
  48. How to create a custom search for custom post type?
  49. Opinions and recommendations on the best barebones base theme [closed]
  50. How to put logs in WordPress
  51. How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
  52. Conditionally Loading JavaScript/CSS for Shortcodes
  53. What is your best practice to execute one-time scripts?
  54. How to get the Date Format and Time Format settings for use in my template?
  55. WAMP vs XAMPP pros/cons – for running a local testing server [closed]
  56. what is the correct way to compare dates in a WP query_posts meta_query
  57. Explanation of update_post_(meta/term)_cache
  58. How to implement a customizable free OpenID authentication?
  59. Should all plugins be encapsulated in a Class?
  60. Add validation and error handling when saving custom fields?
  61. Best way to eliminate xmlrpc.php?
  62. Nested meta_query with multiple relation keys
  63. How To Add Custom Form Fields To The User Profile Page?
  64. Add multiple custom fields to the general settings page
  65. What SQL Query to do a simple find and replace
  66. What Features would you Most Like to See Added to WordPress? [closed]
  67. Why have on every line
  68. Where are Additional CSS files stored
  69. How can I edit post data before it is saved?
  70. How do i best handle custom plugin page actions?
  71. add_action(), add_filter() before or after function
  72. is_plugin_active function doesn’t exist
  73. Best Practices for Regression Testing WordPress Websites?
  74. numberposts? showposts? posts_per_page?
  75. Remove wrapping div and ul from output of wp_nav_menu
  76. Attaching taxonomy data to post with wp_insert_post
  77. What Is The Use Of map_meta_cap Filter?
  78. How do you use a CPT as the default home page?
  79. How to create an API for my plugin?
  80. Is it ever okay to include inline CSS in plugins?
  81. Plugins in symlinked directories?
  82. get post author id outside loop
  83. Difference between add_filter and apply_filters
  84. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  85. Custom pages with plugin
  86. Proper Way to Modify Plugin
  87. Custom Walker: how to get ID in function start_lvl
  88. Pass boolean value in shortcode
  89. How to add crossorigin and integrity to wp_register_style? (Font Awesome 5)
  90. Customizing a WordPress theme without changing it?
  91. Creative uses of WordPress [closed]
  92. WordPress database synch between dev and prod
  93. Can a custom post type have a Parent Page?
  94. Restrict custom post type to only site administrator role
  95. In Which Contexts are Plugins Responsible for Data Validation/Sanitization?
  96. Best practices for localizing WordPress content?
  97. Plugin Form Submission Best Practice
  98. How to *remove* a parent theme page template from a child theme?
  99. get_the_term_list without links in 3.1
  100. How to make a text with hyperlink translatable in WordPress?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)