Importing Direct to DB – GUID Question

Short answer: yes

The GUID field is meant to represent a globally unique identifier for the post. In WordPress we just happen to use the URL. The GUID field should never be thought of as an actual URL, though … just an identifier for the post.

In reality, the GUID field could contain anything that’s unique. But if you have two posts that share the same GUID, you might want to consider bumping one or the other. Importing the CSV of posts into an empty blog and using the WordPress Import/Export mechanism would help. Or setting [n] to be the ID the post will have after import.

Related Posts:

  1. Why is my database import losing text widget data?
  2. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  3. wp_posts – guid update
  4. What’s the database relationship between a post and its attachments
  5. Export WP database for import using WP-CLI on Vagrant Box
  6. Importing posts from old website to new conflicting post ID’s?
  7. When importing database, it shows error
  8. Is a direct or import approach safer for migration into WordPress?
  9. MySQL Syntax Error upon restoring database from backup [closed]
  10. Import live site to local setup without access to live site
  11. Error establishing a database connection; After importing DB & Theme
  12. WordPress database import: Row size too large
  13. Export / import WordPress database
  14. Merging two databases without borking it
  15. Importing CSV into database table not working?
  16. Import users from old WP site to new one
  17. Connection refused on locahost after importing database?
  18. Best practice to import user base (subscribers) from one website to another?
  19. Importer fails to import every post
  20. WordPress database products structure
  21. Is it risky if I update all url in the database due to my site url changed?
  22. Is it good practice to import/export a blog to test a redesign?
  23. Accidently changed the GUID
  24. Featured image from custom to WordPress database
  25. I broke database after reuploading local version – what exactly happened? Database error
  26. Importing Concrete5 content to WordPress
  27. Database synchronization between dev/staging and production
  28. Multiple developers / editors working on a site in progress
  29. WordPress Database lost auto increment
  30. Count & Display Database Queries
  31. Slow wp_term_relationships query
  32. How to use “TRUNCATE TABLE” MySQL statement?
  33. Export wordpress table to excel
  34. Meta query interfering with orderby relevance
  35. save new data to wp_options non-post form
  36. Strange Deadlock database error for the query “Delete From wp_options”
  37. PHP variable in WordPress database query
  38. Differences between add_post_meta and update_post_meta
  39. Why do wordpress store pages/posts within the database instead of files? [closed]
  40. Insert custom data to custom table on wordpress database
  41. Select Multiple meta_value from WP DB; Single Query
  42. One post carries 30 postmeta values, is this too much?
  43. Is it possible to split database tables using HyperDB?
  44. What happens if I overwrite the current wp_options table with a backup from a week ago?
  45. Critical error in final stage of website launch – URLs are BROKEN!
  46. How do I get WordPress login to ignore the password input if a particular username is used?
  47. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  48. “Error establishing a database” connection on some sites
  49. WordPress is not creating table in database after activating plugin,
  50. How do I delete these post types in my WordPress database?
  51. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  52. How do I query wp_options for expired transient pairs with MySQL commands?
  53. WordPress running SQL query to update database from form
  54. Use same database on main domain & sub domain
  55. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  56. Remove empty rows from the database
  57. Custom WordPress Table wpdb
  58. Check if post id exist in table than only update instead of inserting new row
  59. Detail explanation of wordpress database fields and metatag list [closed]
  60. CreateOrUpdate in WordPress
  61. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  62. How to get a list of WordPress default database tables?
  63. Can local WordPress installs share /wp-content/ folder and database?
  64. Stringing together content from different databases
  65. Backing up WordPress database and files
  66. Safely store code(html/js..) into database
  67. Creating and Using Tables in the WordPress Database
  68. Connect a membership plugin to an external database
  69. Compare User meta_value with Product meta_value
  70. Storing user’s data on external database on other server
  71. How to insert a value to decimal type field using wpdb->prepare?
  72. Sql query to get all metadata for a post
  73. Where do I put my create_new_table function()?
  74. How to import products in host instead of database on wordpress?
  75. Having all “non-PHP” files on a different server
  76. syntax error for changing user role from database
  77. Finding a page holding a specific string/URL that is used in the content
  78. “wordpress error in establishing database connection” and missing tables
  79. get_option() does unserialize and don’t remove \
  80. Adding last value from Database as text in WordPress Page
  81. Want to update value in database. But it says update() on null
  82. Merging development site with live site
  83. I have a WordPress 4.6 database dump – how do I use it in a new install?
  84. Checking if the data already exsis in the wp database – custom plugin
  85. live site do not update after importing sql database
  86. Transforming an wp_options database array into a javascript obect?
  87. How can I retrieve data from alternate database using wpdb class?
  88. Database connection close
  89. WordPress Database Charset/Collate
  90. User accounts for saving form data?
  91. Trying to edit a WP site locally using MAMP
  92. How to delete field using WPDB?
  93. Log IP of users who click a button? [closed]
  94. DROP TABLE IF EXISTS `wp_options` error?
  95. Problem with form database connectivity
  96. Server database problem
  97. Best way to search and replace within serialized database strings?
  98. Have WordPress Use a Different Database for users
  99. WordPress post on home page of my website
  100. large number (bigint) for post ID issue in database