Way to extract wordpress data from folder backup

There’s two elements to this:

  1. Restoring the mySQL database which hopefully resided in your wamp folder. This will be where the actual post data is in.

    See

     

  2. Restoring the files themselves. The most straightforward way to do this will be to restore a wamp install from scratch with the same paths and host names as you had before the crash, and then copying the WordPress files from the backup folder into the new live folder.

Unless you manage to recreate everything 1:1, you may need to adjust

  • the mySQL password in the WP install (I think it’s in wp-config.php)

  • path and/or host names; for how to do that, see Moving WordPress

Related Posts:

  1. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  2. How to use mysqli_query() in PHP?
  3. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. MySQL ERROR 1290 (HY000) –secure-file-priv option
  7. MySQL server startup error ‘The server quit without updating PID file’
  8. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  9. How do I quickly rename a MySQL database (change schema name)?
  10. What does SQL Select symbol || mean?
  11. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  12. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  13. Duplicating a MySQL table, indices, and data
  14. mysql Foreign key constraint is incorrectly formed error
  15. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  16. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  17. mysql is not recognised as an internal or external command,operable program or batch
  18. SELECT * FROM multiple tables. MySQL
  19. mysql: SOURCE error 2?
  20. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  21. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  22. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  23. Data truncated for column?
  24. MySQL foreach loop
  25. How to find MySQL process list and to kill those processes?
  26. MySQL IF NOT NULL, then display 1, else display 0
  27. MySQL date format DD/MM/YYYY select query?
  28. MySQL Calculate Percentage
  29. Repair all tables in one go
  30. How can I output MySQL query results in CSV format?
  31. Error: select command denied to user ‘‘@’‘ for table ‘‘
  32. Get the new record primary key ID from MySQL insert query?
  33. How to change collation of database, table, column?
  34. Failed building wheel for mysql-python
  35. MySQL Error 1215: Cannot add foreign key constraint
  36. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  37. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  38. Remove Primary Key in MySQL
  39. How to get the max of two values in MySQL?
  40. mysql: connection refused when trying to connect to localhost using remote IP
  41. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  42. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  43. Complex meta query with 3 keys
  44. How can I find the source of slow queries in WordPress?
  45. How to log mysql errors from wordpress core?
  46. $wpdb and MySQL Create Trigger
  47. wpdb Custom Meta Data with 2 conditions
  48. query to create woocommerce products from images
  49. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  50. Configure WordPress to connect to Mysql DB using SSH tunneling
  51. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  52. Rewrite database urls
  53. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  54. Error while importing database
  55. Migrating from Existing MySQL Setup to WordPress
  56. How to split the a table in database?
  57. Why my wordpress loopback traffic while socket is setup?
  58. How do I join a $wpdb query with user meta using default value if not exist?
  59. mySQL statment count of post in each category and sub category
  60. Paypal Post IPN handeling nightmare
  61. Defining the same price to all WooCommerce Products
  62. Database Structure on Different Servers
  63. Is there a page length limit?
  64. WordPress tables and aliases?
  65. What’s the sql for this condition?
  66. Create a form with custom autocomplete address field and CSV import values
  67. WordPress insert query is not working : Showing no Error
  68. Copy usermeta value where ID matches in the same table
  69. Export Yoast Keywords from MySQL/phpMyAdmin
  70. Same database; different WordPress
  71. Some Post Content Does Not Show Up In DB Search
  72. How can I write a formal sql query to get data from a custom table
  73. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  74. Upgrade DB Loop – WordPress DB Version Conflict
  75. WordPress & MySQL , problem with use many array in meta_query
  76. Button writing to MYSQL database
  77. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  78. MySQL ‘duplicate entry’ error
  79. Find locations of all featured images of draft posts via SQL
  80. WordPress Dutch characters encoding problem
  81. How to show result of sql query in a page?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. How do I insert content of various MySQL fields in post?
  84. How to change link in all posts?
  85. Select latest 2 articles, but only from given category
  86. CONCAT_WS in custom sql query
  87. Query does not filter duplicate _sku numbers
  88. Ordering topics by most replies in X days using MYSQL statement
  89. MySQL Select within WP Page template
  90. wp_postmeta – lot of meta fields
  91. Running WordPress from MySQL Cluster with HAPRoxy
  92. Delete posts with word count less than x number of words
  93. MySQL: get post_tag items that are tags (not SEO keywords)
  94. $wpdb->get_var returns 0
  95. cannot log in to the mysql server (wamp and wordpress)
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  98. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  99. How do I load a sql.gz file to my database? (importing)
  100. Batch Replace URLs in WordPress Database