How to backup and restore configurations

You must export all table beginning with your WordPress prefix.

  1. Open your phpmyadmin panel.
  2. Then open your wordpress database.
  3. Click “export” from top menu.
  4. Select “Export Method:” as custom.
  5. Select your all tables beginning your prefix.
  6. Then go to bottom of page click “go”.

You got your SQL file. Move all files to new directory. If you create a new database on new host, you must change the database name on wp-config.php.

  • Then you must import your SQL file to new database.

  • Replace the old domain name with the new domain name. Go to wp_options table on your database.

  • Change siteurl option name. on second page change “home” option name with new url.

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 perform WordPress backups using wp-cli?
  6. WordPress Admin Interface not styled properly
  7. Is it possible to create a WordPress backup by simply copying it?
  8. Updating to new 3.0.5
  9. Managing Backups: Space Issues [closed]
  10. WordPress staging environment that syncs everything except posts?
  11. Which Blog Client for Windows/Linux has the best support for backing/restoring your posts?
  12. WordPress manual restore not completely successful
  13. Backup custom table
  14. Backup localhost (wamp) database (phpmyadmin) from harddrive files on windows? For WordPress?
  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. Restore large number of permanently deleted posts
  20. Can I Restore My Website Pages Without mySQL Database?
  21. How can I make revisions more extensive?
  22. what to backup (for partial restore)??
  23. Backing up an old version of WP before upgrading
  24. How to restore all items from trash
  25. BackupBuddy, for backups, backups in general etc, any good?
  26. How do you “test-restore” a backup?
  27. How to fully backup a WordPress site?
  28. How do I passively back-up my WordPress websites on a frequent basis? [closed]
  29. How to setup a wordpress backup in localhost?
  30. How to completely save my wordpress data?
  31. Can I delete .git folder in a completed WP project?
  32. Auomated crash recovery?
  33. back up fully Customized WordPress theme [closed]
  34. Restoring from a old local copy of xampp folder where the project was stored
  35. WP was redirecting to install.php, I installed again and replaced old files with new one but lost all data
  36. Can I roll back WP Install but keep my newer database?
  37. How to Backup and Transfer Everything to Another WordPress Site?
  38. Duplicated WordPress Site STILL Linked to Old Site
  39. Backup wordpress installation on shared hosting
  40. Using database in new instalation
  41. How to copy a WP website to new domain name?
  42. Why is RAID not a backup?
  43. GIT as a backup tool
  44. How to backup 20+TB of data?
  45. How to keep the full path with rsync?
  46. How to backup my plugin database [closed]
  47. Reading settings from app.config or web.config in .NET
  48. Encrypt Password in Configuration Files?
  49. Adb backup does not work
  50. What’s the simplest way to backup my WordPress database?
  51. Control verbosity level of WP DEBUG?
  52. How do I transition multiple installations to a single Multisite installation?
  53. How to use live images on local install?
  54. Plugin for automatic database backup? [closed]
  55. Add robots.txt to root
  56. What is the best WordPress plugin for Amazon s3 backups? [closed]
  57. How to clone and locally run a network for testing
  58. Set wp-content folder to Dropbox folder
  59. Allow download_url for lan addresses
  60. Recover from failed multisite conversion
  61. Why are no posts showing despite my apparently correct DB restoration?
  62. Set WP_MAX_MEMORY_LIMIT higher than PHP.ini memory_limit
  63. nginx.conf appeared in all WordPress installations on folder
  64. Gutenberg Block Development: Trying to add custom js script to npm start command by modifying webpack.config
  65. WordPress Ignoring .user.ini
  66. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  67. Store partial database to an archive database time to time
  68. Issues copying site into local machine
  69. Show wordpress locally in xammp and in iPhone via ip
  70. Why when I try to access to this old WordPress site it is opened the installation page?
  71. Backing up WordPress database and files
  72. “GET / HTTP/1.1” 304 186 “-” inside access_log for a WordPress site, but the admin side works
  73. For a complete backup, is it enough to copy htdocs and export database?
  74. How do you set the default page in WordPress?
  75. can’t upgrade wordpress or install plugins, it seems to “think” it’s still on a local installation
  76. Automatic WordPress Backup Plugin works, but says it’s not
  77. XML Sitemap Generator and 404 problem
  78. Is it possible to restore a deleted WordPress plugin I deleted from WordPress admin menu?
  79. Changes not being reflected on new server
  80. SQL database import #1046 error
  81. Advice On How to Backup WordPress
  82. How to transfer all posts, pages and media
  83. Front-end pages messed up due to HTTPS
  84. How can I export data without using any import/export plugin
  85. blank page after update my theme
  86. Backup Restore turns carriage returns to literal strings
  87. I have a WordPress 4.6 database dump – how do I use it in a new install?
  88. Find/ascertain latest wordpress db from multiple database copies
  89. Best way to move a site to a subfolder for testing purposes?
  90. Inactive Plugin Files
  91. Best method to upgrade WordPress and Plugins
  92. How to replace a wordpress installation in root directory with another in a subdirectory?
  93. Where do I add my own configuration needs and how do I access them?
  94. Backup Buddy Questions
  95. How to Move a production WordPress site to local environment [closed]
  96. What’s the cleanest way to transfer WordPress to a new server
  97. How to check for modified config files on a Debian system?
  98. restore backup full content or just specific folders
  99. Do Not Back Up? Is there any accepted way to tell backup and clone plugins to skip a certain file? [closed]
  100. Upgrading from WordPress 3.8.2 to latest – only files and SQL dump available