Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?

Don’t know if it’s the best way but her is a very simple way to do it:

  1. Install a new copy of WAMP.
  2. Copy the files from the old HD to you newly installed wamp
    \bin\mysql\mysql...\data folder.
  3. Log in to phpmyadmin (that comes with WAMP) and create a dump of
    the database

Related Posts:

  1. Postgresql 9.2 pg_dump version mismatch
  2. What is a better way to backup files than FTP?
  3. What is the best method to export local WordPress installation and import to live server?
  4. How to Add Back Buttons to Web Pages [closed]
  5. How to backup and restore configurations
  6. How to perform WordPress backups using wp-cli?
  7. WordPress Admin Interface not styled properly
  8. Is it possible to create a WordPress backup by simply copying it?
  9. Updating to new 3.0.5
  10. Managing Backups: Space Issues [closed]
  11. WordPress staging environment that syncs everything except posts?
  12. Which Blog Client for Windows/Linux has the best support for backing/restoring your posts?
  13. WordPress manual restore not completely successful
  14. Backup custom table
  15. Restored my site using a backup. Seems to be OK but the posts are empty?
  16. Backing up WordPress before an update, what’s the easiest way to do this?
  17. Restoring backup of wordpress website on LAMP
  18. Recover wordpress by replace file manually
  19. Backing up and restoring multiple sites efficiently
  20. Restore large number of permanently deleted posts
  21. Restose content from revisions – sql query
  22. Can I Restore My Website Pages Without mySQL Database?
  23. How can I make revisions more extensive?
  24. Update a buggy installation
  25. what to backup (for partial restore)??
  26. Backing up an old version of WP before upgrading
  27. How to restore all items from trash
  28. BackupBuddy, for backups, backups in general etc, any good?
  29. How do you “test-restore” a backup?
  30. How to periodically roll back WordPress to a fixed point in time?
  31. How to fully backup a WordPress site?
  32. How do I passively back-up my WordPress websites on a frequent basis? [closed]
  33. Backing up WordPress database and files
  34. How to setup a wordpress backup in localhost?
  35. How to completely save my wordpress data?
  36. Can I delete .git folder in a completed WP project?
  37. Auomated crash recovery?
  38. back up fully Customized WordPress theme [closed]
  39. Restoring from a old local copy of xampp folder where the project was stored
  40. WP was redirecting to install.php, I installed again and replaced old files with new one but lost all data
  41. Can I roll back WP Install but keep my newer database?
  42. How to Backup and Transfer Everything to Another WordPress Site?
  43. Duplicated WordPress Site STILL Linked to Old Site
  44. get backup file from wordpress database in x days
  45. Backup wordpress installation on shared hosting
  46. Using database in new instalation
  47. How to copy a WP website to new domain name?
  48. Why is RAID not a backup?
  49. GIT as a backup tool
  50. How to backup 20+TB of data?
  51. How to keep the full path with rsync?
  52. How to backup my plugin database [closed]
  53. Backup Site Data from a Bitnami WordPress instance
  54. http://localhost/phpMyAdmin/ unable to connect
  55. How to log in to phpMyAdmin with WAMP, what is the username and password?
  56. phpMyAdmin access denied for user ‘root’@’localhost’ (using password: NO)
  57. phpMyAdmin Error: The mbstring extension is missing. Please check your PHP configuration
  58. mysqli_real_connect(): (HY000/2002): No such file or directory
  59. Setting up foreign keys in phpMyAdmin?
  60. phpMyAdmin: secret passphrase?
  61. Forbidden :You don’t have permission to access /phpmyadmin on this server
  62. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  63. mysqli_real_connect(): (HY000/2002): No such file or directory
  64. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  65. “Connection for controluser as defined in your configuration failed” with phpMyAdmin in XAMPP
  66. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  67. MySQL Error #1133 – Can’t find any matching row in the user table
  68. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  69. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  70. mysql said: Cannot connect: invalid settings. xampp
  71. How to create a foreign key in phpmyadmin
  72. This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available
  73. importing a CSV into phpmyadmin
  74. MySQL: Can’t create table (errno: 150)
  75. Adb backup does not work
  76. input file appears to be a text format dump. Please use psql
  77. MySQL: How to reset or change the MySQL root password?
  78. Delete a database in phpMyAdmin
  79. PHPMyAdmin Default login password
  80. How to extract or unpack an .ab file (Android Backup file)
  81. MySQL Daemon Failed to Start – centos 6
  82. wamp server mysql user id and password
  83. phpmyadmin “Not Found” after install on Apache, Ubuntu
  84. Delete a database in phpMyAdmin
  85. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  86. Auto increment in phpmyadmin
  87. Moving WordPress from MAMP to WAMP, can’t access pages
  88. Moving WordPress from MAMP to WAMP, can’t access pages
  89. UpdraftPlus WordPress plugin is not working to store Backup in the Google Drive
  90. Redirecting to old domain after migration
  91. What’s the simplest way to backup my WordPress database?
  92. Making someone a WordPress administrator using PhpMyAdmin
  93. Mysqldump add drop table?
  94. Backup the Database and Restore from the Backup?
  95. Does wpdb add considerable overhead on queries with large result sets?
  96. How to keep a WordPress site synchronized between two servers?
  97. How do I find all admin users using phpmyadmin?
  98. Problem: Create a cron job to export posts to a WordPress XML file on server
  99. What specific database privileges does WordPress need?
  100. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)