Moving to another host; which tables to move in a database

I never personally tried this, but your images and posts reside in your {prefix}posts (wp_posts) table. I would also copy {prefix}postmeta (wp_postmeta) over.

So copying over those table should do what you want.

Keep in mind that this won’t copy your categories and tags (meta), and your comments (comments) they reside in other tables, you could find those easily they have meta and comments in their names. Copy those too if you want that.

Related Posts:

  1. WordPress Unit Testing – Cannot Create Tables
  2. Insert data in database using form
  3. When is it appropriate to create a new table in the WordPress database?
  4. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  5. BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
  6. stdObject stored in database. How does one convert it to usable format?
  7. Database with mixed collation (utf8mb4 & utf8_general_ci)
  8. WordPress mysql table double prefixes
  9. Change WordPress prefix for only one table?
  10. input data and output table [closed]
  11. Retrieve data from the database to table such as comments in the admin control panel
  12. Change options table prefix only
  13. Query multiple tables at once?
  14. Why does changing Database Table Prefixes result in loss of content?
  15. Can I customised default WP table
  16. Should I use an additional column in the DB?
  17. Will adding & modifying default WordPress table index break future WordPress update
  18. What is wrong here? Issue with post_id and meta_value
  19. How to edit custom table data in frontend
  20. How to map data on CSV to web pages?
  21. Create hundreds of users with just ID in phpMyAdmin
  22. Have WordPress Use a Different Database for users
  23. Database table prefix different between wp-config.php and in database
  24. Count views without get_post_meta
  25. Is it fine to have foreign key as primary key?
  26. Detecting errors generated by $wpdb->get_results()
  27. wpdb update add current timestamp not working
  28. Custom form that store input in database
  29. Restoring WordPress posts from database only
  30. Displaying content from one WP site on separate WP site
  31. Lost the `wp_options` table: what’s the best way to restore the site?
  32. Performance Gains of Relational DB Setup
  33. store simple data in get_option()
  34. What are conventions about the schema of the $table_prefix
  35. storing database in version control
  36. Is deleting orphaned wp_options entries safe?
  37. How to build a movie database with wordpress?
  38. Sub-domain or 2nd, temporary different domain?
  39. How do i get user data from a custom table in the wordpress database by user ID?
  40. Converting WordPress into Android or iPhone app
  41. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  42. Database slowdown after update to 3.4.1
  43. WooCommerce sku location in DB
  44. How to insert data into MySQL database from the form created in WordPress site
  45. Emoji support and MariaDB 10.0.30-
  46. Can I have multiple database users within WordPress?
  47. How do I copy a wordpress database?
  48. What happens if I overwrite the current wp_options table with a backup from a week ago?
  49. CRUD operations using WordPress database API
  50. Display SQL that wordpress is running
  51. Critical error in final stage of website launch – URLs are BROKEN!
  52. How to resolve Connections using insecure transport are prohibited while –require_secure_transport=ON
  53. How to Mirror WordPress database from Remote server to Local server
  54. WordPress returns to an old version
  55. data (html) migration to posts
  56. Super slow queries from author archive pages killing my database
  57. localize elements in database
  58. Check if an option exists and get its value in one hit
  59. Problems with moving my WordPress site to another domain/server
  60. Is it important to have integers inserted using %d rather than %s?
  61. Export a custom Mysql database product catalog to WordPress
  62. Connect to database in the header of my WordPress website
  63. WordPress url transformation script
  64. Location of WP default mySQL tables creation file?
  65. Creating a search form and displaying results
  66. Is it risky if I update all url in the database due to my site url changed?
  67. Just created a WordPress Table can’t get $wpdb get row to work – need help
  68. Custom Database Table and foreach
  69. $wpdb->insert not inserting all rows
  70. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  71. How can I find user role in Mysql?
  72. How would I see which wordpress posts have a revision history without opening each one?
  73. Creating a custom form with ability to query and submit to SQL
  74. Troubles when I want to connect to another DB
  75. Intermittent Yet Problematic Error – “Error Establishing A Database Connection”
  76. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  77. WordPress Database Query works in phpMyAdmin but not in the code
  78. Error: SHOW FULL COLUMNS FROM `pt_participant`
  79. update to a new template without loosing any data
  80. How to save dropdown slection by a user in the DB
  81. Form display in new page
  82. spambot registering without providing email or password, bypassing registration process
  83. Connection of mysql DB with wordpress
  84. Locally installing wordpress. Database problem
  85. I have my full special database from xampp how can i use this on wordpress?
  86. Halting data inserts for future refresh of post?
  87. Possible to restore wordpress database from mysql56 and sqlite files?
  88. Options table – where does my values go?
  89. How can I safely delete data related to wp_post table manually from the mysql database?
  90. Copy site on same server?
  91. Changing database links has no effect
  92. How to use remote db tables in current config? [duplicate]
  93. WordPress can’t fetch the posts from the database after moving to new server [closed]
  94. why you don’t Implement PDO for access every thing to database
  95. Restrict users viewing post using age on database [closed]
  96. What’s the cleanest way to transfer WordPress to a new server
  97. Display custom data based on URL slug
  98. How to protect my credentials on my clients website
  99. How to disable publish_future_post auto add wp_options cron
  100. I have uploaded thousands of files in the uploads folder via FTP and I want to register them into the database without any plugin