Import live site to local setup without access to live site

The steps to take would be:

1 – Extract files

2 – Create DB and import

3 – modify wp-config.php for database name and user credentials if changed

Do not modify db tables to change the site url as they are serialized and this will create more issues than you want to deal with.

4 – Use a script like searchreplacedb.php to search and replace all of the urls in the database with the new url.

Related Posts:

  1. Design problems when exporting remote database for local development
  2. Cloned site not connecting to database – MAMP
  3. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  4. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  5. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  6. Why is my database import losing text widget data?
  7. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  8. What’s the database relationship between a post and its attachments
  9. Export WP database for import using WP-CLI on Vagrant Box
  10. Importing posts from old website to new conflicting post ID’s?
  11. Connect to remote database using Localhost install
  12. When importing database, it shows error
  13. Best way to move live site local
  14. Have multiple local wordpress installs share a wp-content folder and database
  15. Connect to live db whilst working locally
  16. Is a direct or import approach safer for migration into WordPress?
  17. MySQL Syntax Error upon restoring database from backup [closed]
  18. Moving online website to MAMP or dumb idea?
  19. Error establishing a database connection; After importing DB & Theme
  20. Moving minor updates between local and live sites – just database?
  21. WordPress database import: Row size too large
  22. Connect to a remote database for wordpress in my own hosting server
  23. Export / import WordPress database
  24. Difficulty importing my live site to local
  25. Merging two databases without borking it
  26. Importing CSV into database table not working?
  27. Import users from old WP site to new one
  28. Connection refused on locahost after importing database?
  29. Importing Direct to DB – GUID Question
  30. Best practice to import user base (subscribers) from one website to another?
  31. Importer fails to import every post
  32. Problem migrating to localhost
  33. Can local WordPress installs share /wp-content/ folder and database?
  34. WordPress database products structure
  35. How to transfer from localHost to live but use the already existing database on the server?
  36. Image link issues after importing a database backup to my local web server
  37. Installing local to live WP into subdirectory
  38. Is it good practice to import/export a blog to test a redesign?
  39. Database migration issues – Error #1046 No database selected
  40. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  41. Cloning blog to localhost via WAMP
  42. New installation fatal error in 5.9.3 at edit or create entry
  43. Recovery – Restore Database after moving folder location locally
  44. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  45. Error establishing a database connection with XAMPP
  46. Featured image from custom to WordPress database
  47. Search and Replace in Windows XAMPP site
  48. Locally installing wordpress. Database problem
  49. I have my full special database from xampp how can i use this on wordpress?
  50. Does WordPress Support Using Named Pipes on the Windows Operating System?
  51. Local Content different from Remote Content
  52. How can I work on a database along side a client?
  53. Restoring .sql backup results in “Error establishing a database connection”
  54. I broke database after reuploading local version – what exactly happened? Database error
  55. Trying to edit a WP site locally using MAMP
  56. Importing Concrete5 content to WordPress
  57. Theme Options – localhost to new url
  58. Can I connect WordPress website with an external database?
  59. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  60. Connect to database using wordpress wp-config file
  61. Does wpdb add considerable overhead on queries with large result sets?
  62. wp_users user_status field
  63. Display data from a non wordpress database on a page template
  64. Is it possible to switch the data layer within WordPress?
  65. Should I hint table index for search query on wp_post
  66. Connecting to external oracle database
  67. Multiple installation in a single database
  68. Huge wp_options table
  69. Can’t save ajax value to database
  70. Block search SQL from happening
  71. wp_options table has duplicate rows and primary key / autoincrement has been removed
  72. WP All Import – Using Xpath to set a select value
  73. Where are WP_Errors Saved
  74. Get all images from this database table
  75. Delete transients in website
  76. Error establishing database connection – high traffic?
  77. Bulk-create posts from SQL database
  78. Is there a solution to auto-post data to a WP post from a database
  79. Moving a remote WordPress multisite installation to local
  80. All text disappeared (seems to be a database problem) [closed]
  81. is wordpress stores Role Id in WP database?
  82. Why do database examples sometimes finish with an add_option call?
  83. How to transform a custom made static HTML website to a WordPress website [closed]
  84. How to backup my site and restore my wordpress site
  85. How and where is wordpress adding mySQL content to database?
  86. How get Data form wordpress database as array not stdclass?
  87. cannot connect database
  88. How to delete a particular row in a database table
  89. Connecting to wordpress database in my application [closed]
  90. WordPress keeps redirecting to localhost
  91. get value from ‘terms’ table
  92. custom tables in wordpress Database? (can i just create them with sql?)
  93. Displaying requested data from a the database in wordpress
  94. Accidently changed the GUID
  95. Not sure what to do next to optimize
  96. $wpdb not working
  97. Accessing content from third party as native posts in WordPress
  98. Fetch data from another site, but the same database
  99. Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
  100. Upload wordpress from localhost to 000webhost