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. Is it fine to have foreign key as primary key?
  60. Restoring WordPress posts from database only
  61. Performance Gains of Relational DB Setup
  62. store simple data in get_option()
  63. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  64. storing database in version control
  65. Is deleting orphaned wp_options entries safe?
  66. How to build a movie database with wordpress?
  67. Sub-domain or 2nd, temporary different domain?
  68. How do i get user data from a custom table in the wordpress database by user ID?
  69. Converting WordPress into Android or iPhone app
  70. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  71. WooCommerce sku location in DB
  72. Can I have multiple database users within WordPress?
  73. CRUD operations using WordPress database API
  74. Display SQL that wordpress is running
  75. How to resolve Connections using insecure transport are prohibited while –require_secure_transport=ON
  76. Can you create a local wordpress network / multisite install on a mac with subdomains?
  77. WordPress returns to an old version
  78. data (html) migration to posts
  79. Super slow queries from author archive pages killing my database
  80. localize elements in database
  81. Best practice to limit results in get_row()?
  82. Which table (and column) has the content of configured get_post_meta?
  83. Serialize data before inserting into the DB
  84. Pages from custom table
  85. Can I customised default WP table
  86. Woocommerce – Check product stock availability from external database
  87. How to display data from db in select list [closed]
  88. Will adding & modifying default WordPress table index break future WordPress update
  89. echo site_url() returns a different value than what is in the database siteurl field
  90. Native timestamp on wp_options option
  91. SELECT rows between two datetimes when the range is dynamic [closed]
  92. error establishing a database connection 3
  93. modifying htaccess for localhost with a custom port
  94. Correct and secure way to access a custom SQL database in a custom PHP template file
  95. Missing latest posts and options after DB migration via phpMyAdmin
  96. Custom metabox does not store data
  97. Local host to server import problem
  98. featured image not showing up with mysql_connect
  99. Options of accessing wordpress data from mobile app
  100. Order of search results based off of a backend custom field and also in alpha order