Migrating data between local and development server

Assuming your wp-config.php is already in place and in order:

  • Step 1. Mysqldump your development database
  • Step 2. Replace all instances of development.domain.com to production.domain.com^^
  • Step 3. Login to MySQL, run a SOURCE command to import data e.g. source /path/to/file

^^ How to replace all instances of old domain with new: (1) Copy the script below. (2) chmod +x it. (3) Run it.

Usage: ./script.sh development-dump.sql > production-dump.sql

#!/bin/sed -f
s/'\([^\\']*\)development.domain.com\([^\\']*\)"https://wordpress.stackexchange.com/"\1production.domain.com\2'/g

Related Posts:

  1. Syncing local content with development / staging sites
  2. Keeping WP database synced across multiple developers using git
  3. Multiple developers / editors working on a site in progress
  4. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  5. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  6. Solution for database version control and deployment?
  7. How to migrate a HTTPS WordPress installation to localhost?
  8. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  9. Best way to import users, post and categories from an external database
  10. Organizing WP Pages based on old website database
  11. Presentation vs Content in WP DB-Tables
  12. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  13. Migrate a Non WordPress database to wordpress [closed]
  14. storing database in version control
  15. Weird issue with database migration and SSL links
  16. How to fix unchanged URLs in Database after running serialized search and replace script?
  17. Trigger Plugin database update after git pull
  18. Migrating database / content of non-CMS site to WordPress
  19. How do I reset a self-hosted WordPress URL?
  20. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  21. Export all content from wordpress
  22. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  23. Moving minor updates between local and live sites – just database?
  24. How to get the SQL of the changes made to the database from an update or upgrade?
  25. How to move the WordPress site Layout from test site to Production site?
  26. Merging two databases without borking it
  27. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  28. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  29. Trouble Migrating all data blog from WordPress.com to WordPress.org
  30. Copying database tables to new database
  31. Migrating from PDO using SQLite to clean new install using MySQL
  32. Migration: Copying database content to a different server
  33. Change WordPress URL in sql file via Terminal
  34. Strange characters added to the database
  35. After database migration, theme mods don’t show [closed]
  36. Problem migrating to localhost
  37. WordPress url transformation script
  38. How to transfer from localHost to live but use the already existing database on the server?
  39. Image link issues after importing a database backup to my local web server
  40. SymmetricDS in dev + prod workflow?
  41. Database migration issues – Error #1046 No database selected
  42. echo site_url() returns a different value than what is in the database siteurl field
  43. Migrate Users From laravel to wordpress
  44. /wp-admin not accessible after migrating to local host (no plugin issue)
  45. How to fix Uploaded to this post option to see group of images uploaded to a post?
  46. How do you enable scripts on a WordPress installation in Softaculous?
  47. Is there an actual way to synchronize ‘production’ and ‘develop’ WordPress databases?
  48. WordPress site migration – locked out of admin area
  49. Malware in old website – how to migrate?
  50. WP website showing blank page after moving from subdomain to main domain
  51. WordPress Migration – Issue with admin panel changes
  52. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  53. How to edit posts/pages without making the change live?
  54. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  55. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  56. I cannot change anything in my wordpress database from within wordpress?
  57. Media library images “missing” after migrating them using SQL
  58. version control for wordpress? (wordpress folder and database at same time)
  59. Restoring .sql backup results in “Error establishing a database connection”
  60. import (migration) user database to wp-users
  61. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  62. Working local with one database
  63. Moving database from WP 2.6 to 3.5 problem
  64. Importing Concrete5 content to WordPress
  65. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  66. What is this JavaScript “require”?
  67. How can I make a WordPress database portable and url independent?
  68. wpdb->insert multiple record at once
  69. Login in WordPress using external database data
  70. Shared Members between two different wordpress installations with different databases
  71. Efficiency on displaying random authors based on large database
  72. How to write Hebrew characters?
  73. Error establishing a database connection – with Debug Data
  74. Finding the login page from database?
  75. When and why should I use $wpdb different return types?
  76. Database with mixed collation (utf8mb4 & utf8_general_ci)
  77. Adding new row to wp_post table
  78. Extracting the post_id via the wp_insert_post action (external db query)
  79. How to interact with another wordpress install on same database?
  80. Saving into post_excerpt or post_content
  81. Maintain user profile data in a non-WordPress database
  82. How to fix the disappearance of the “\” character when updating a post in the database
  83. How can I push local database changes to production, without impacting recent posts/pages that were published on production server?
  84. Setup private content for specific users with daily updates [closed]
  85. WSOD 3.9.1 – Tried Everything so far
  86. Sending posts from Python to WordPress
  87. How do you render posts from outside wordpress?
  88. Second ezSQL initialization for MSSQL
  89. Fetch a single row from a custom table for to a given ID
  90. Database create or redirect
  91. Database structure cheatsheet
  92. White Screen in Home Page
  93. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  94. WordPress has been updated! Before we send you on your way, we have to update your database to the newest version
  95. Should I Use only wpdb Class to Write Custom Queries?
  96. Auto populate form fields based on serial input or pull listings from other websites?
  97. Error establishing a database connection for some files
  98. Weird characters in title if it contain “ ”
  99. One information repeated on multiple locations on one site [closed]
  100. Showing Error(TAble already exist)

Leave a Comment