How do I copy a wordpress database?

The same WordPress Codex has a page for backing up your database with phpmyadmin; see http://codex.wordpress.org/Backing_Up_Your_Database

You must export and import the database itself – and not do a posts export from the dashboard – to retain all settings, image URLs, etc.

Either use phpmyadmin in your host control panel, or you can use it as a plugin called Portable phpmyadmin: http://wordpress.org/extend/plugins/portable-phpmyadmin/

But if you use the plugin, you may have to try an older version, as the newer alpha version doesn’t work on some web hosts due to host restrictions.

And, if you are changing domains as well as hosts, you need to correctly change URLs in the database. interconnectit.com WordPress Serialized PHP Search Replace Tool

Related Posts:

  1. Restoring WordPress posts from database only
  2. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  3. “Error establishing a database connection” – Intermittent error on GoDaddy
  4. Best host for running large mem and processor intensive WordPress sites?
  5. restore a db after bad backup
  6. Is my way to change WordPress server is correct?
  7. database error WordPress move from one hosting to other
  8. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  9. trying to install wp but i have no clue on hosting and servers [closed]
  10. Can I connect WordPress website with an external database?
  11. phpMyAdmin – Error > Incorrect format parameter?
  12. Difference between partition key, composite key and clustering key in Cassandra?
  13. How SID is different from Service name in Oracle tnsnames.ora
  14. What is a relation in database terminology?
  15. Why is my database import losing text widget data?
  16. Why WordPress choose data serialization over json_encode?
  17. Are There Any Plans for WordPress to Support Databases Other Than MySQL?
  18. Reset Post IDs to less than 64bit integer
  19. how can get database name in wordpress?
  20. Does WordPress use the InnoDB engine for MySQL by default?
  21. $wpdb->prepare() warning in WordPress 3.5
  22. Best way to import users, post and categories from an external database
  23. Performance tips for a large user base [closed]
  24. How to delete outdated, wrongly sized images in _wp_attachment_metadata?
  25. Long option names fail silently?
  26. wp_options is GB in size
  27. Can’t update database after wordpress update from 3.8.1 to 4.4.1
  28. Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
  29. WordPress and automated MySQL backups to a different host
  30. Size article thumbnails and retrieve them directly from database
  31. Should I be able to run two different “close” code versions of wordpress with the same DB
  32. For WordPress is there content in the database which I can safely ignore?
  33. How can I UN-orphan media files?
  34. Does WordPress always create unique passwords?
  35. Merge two WordPress installations into one, and keep posts separated?
  36. Export / import WordPress database
  37. WordPress choose wrong database
  38. Sync user meta data to a second database
  39. Is it safe to delete unnecessary user metadata?
  40. Improve performance by removing unnecessary database queries
  41. WordPress Relational Database
  42. wp-cli search is returning ‘search’ is not a registered subcommand of ‘db’
  43. Switching Databases in LocalHost
  44. cache specific data?
  45. wp_insert_post causing There was an error connecting to the database: Access denied for user ‘root’@’localhost’ (using password: NO)
  46. How to update the values when the featured image has changed?
  47. Does WordPress $wpdb functions wait when table is locked?
  48. Unable to set a default serialized array using dbdelta()
  49. Importing 10 Years of Media into the WP Database
  50. 2 WordPress sites with 2 databases but sharing the same users
  51. Insert Query not working in the form
  52. connecting to DB from custom php file
  53. Make changes of wp-db.php file persistent against updates
  54. Importer fails to import every post
  55. Change the default data installed when setting up WordPress
  56. Clear Terms from Taxonomy for Specific Post IDs?
  57. Buddypress avatar image in database [closed]
  58. WordPress security [closed]
  59. How to split the WordPress database?
  60. $wpdb->get_var – What value is returned when zero records are found?
  61. SymmetricDS in dev + prod workflow?
  62. Fixing YARPP plugin FULLTEXT MySQL indexing
  63. Advantages of dbDelta
  64. Only allow user to access a link once a year, based on their joining date
  65. Error establishing a database connection in wordpress site , website not opening
  66. Counting post and changing roles in mysql database. Query not code
  67. wpdb Insert unknown post data dynamic foreach loop
  68. How do I use a database in a custom theme?
  69. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  70. “BS_” rows in postmeta table
  71. Migrating meta_key and meta_value from old theme to new one
  72. How do you enable scripts on a WordPress installation in Softaculous?
  73. How to rerieve comments and their replies from DB
  74. Inserting data with Geometry field
  75. I Want a More Concice Form of Data than an Array
  76. Export only a part of the database for migration
  77. Why am I being prompted to reinstall wordpress?
  78. Duplicate database to roll back theme & content changes
  79. Select data from foreach loop and send it to wordpress database
  80. mySQL database size large, but tables size less
  81. Error establishing database connection error during first WordPress run
  82. Same DB for live and dev versions
  83. update multiple user meta field based on another meta field
  84. After renaming MySQL database, I can no longer access my Blog page
  85. execute custom function on database connection error
  86. Call to a member function insert()
  87. Create a new table on the database and save parameters from a contact form
  88. version control for wordpress? (wordpress folder and database at same time)
  89. not saving post in wp_post wordpress database table
  90. How to add data from wordpress tables to new database tables you have created
  91. Creating Tables in WordPress Database
  92. Install WordPress with SQL database
  93. How to back-up a database on IIS
  94. Creating Job Tickets
  95. Best db table structure for users with many records
  96. Where are database files of a WordPress website?
  97. SQL query to rewrite all media URLs to end with .webp
  98. wp-config was suddenly updated
  99. Weird WP -Cli Error Connection Refused
  100. How to find fresh (last modified) and sql backup?