Error while importing database

When exporting from original database you should choose to create the tables if they dosn’t exist (First error). If you didn’t choose that option (in phpMyAdmin that option exists, not sure in other database tools), the import file can not create the tables for your and you need to create then prior to start importing it.

For second and third error, you should upgrade your database version to MySQL 5.5.3 or later. Although WordPress can run on MySQL 5.0+, the recommended MySQL version is 5.6 or greater. The problem is that WordPress updates the database to use utf8mb4 if database version is 5.5.3 or later, so probably the source database version was greater than 5.5.3 and the destination database version is lesser than 5.5.3.

If you can not upgrade the destination databser version, edit the import file to change the collation utf8_general_ci and character set to utf8.

Lood for lines similar to:

SET character_set_client  = utf8mb4 ;
SET character_set_results = utf8mb4 ;
SET collation_connection  = utf8mb4_unicode_ci;

and change them.

Related Posts:

  1. How do I import an SQL file using the command line in MySQL?
  2. Unknown collation when I import a dump from an existing site into a development database?
  3. Create a form with custom autocomplete address field and CSV import values
  4. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  5. Exporting completed webiste for another server
  6. Export SQL query based on custom field?
  7. latency problems with wordpress install (from SQL import)
  8. Weird characters displayed when importing WordPress MySQL db
  9. How do I load a sql.gz file to my database? (importing)
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  12. MySQL Error “Operand should contain 1 column”
  13. How to use MySQL DECIMAL?
  14. MySQL ERROR 1290 (HY000) –secure-file-priv option
  15. MySQL server startup error ‘The server quit without updating PID file’
  16. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  17. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  18. Duplicating a MySQL table, indices, and data
  19. mysql Foreign key constraint is incorrectly formed error
  20. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  21. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  22. SELECT * FROM multiple tables. MySQL
  23. mysql: SOURCE error 2?
  24. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  25. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  26. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  27. MySQL foreach loop
  28. MySQL IF NOT NULL, then display 1, else display 0
  29. MySQL Calculate Percentage
  30. Repair all tables in one go
  31. Error: select command denied to user ‘‘@’‘ for table ‘‘
  32. Get the new record primary key ID from MySQL insert query?
  33. How to change collation of database, table, column?
  34. Failed building wheel for mysql-python
  35. MySQL Error 1215: Cannot add foreign key constraint
  36. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  37. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  38. Remove Primary Key in MySQL
  39. How to get the max of two values in MySQL?
  40. mysql: connection refused when trying to connect to localhost using remote IP
  41. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  42. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  43. Complex meta query with 3 keys
  44. How can I find the source of slow queries in WordPress?
  45. How to log mysql errors from wordpress core?
  46. $wpdb and MySQL Create Trigger
  47. importing data from non-wordpress mysql db
  48. wpdb Custom Meta Data with 2 conditions
  49. query to create woocommerce products from images
  50. Insert post without actions/hooks
  51. Import 10,000 Users into WordPress WITH a specific ID for each user
  52. Configure WordPress to connect to Mysql DB using SSH tunneling
  53. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  54. Rewrite database urls
  55. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  56. Changing Table Prefix for an Existing WordPresss Site
  57. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  58. Connect another DB and fetch records from some tables
  59. Can I restart MySQL engine when WordPress website is live?
  60. Error: MySQL shutdown unexpectedly [closed]
  61. Why my wordpress loopback traffic while socket is setup?
  62. Update or insert meta key value – On Duplicate key update
  63. Connect to MySQL using Windows Authentication
  64. Defining the same price to all WooCommerce Products
  65. Database Structure on Different Servers
  66. How to get INSERT errors from $wpdb?
  67. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  68. string literals in query
  69. Export Yoast Keywords from MySQL/phpMyAdmin
  70. Same database; different WordPress
  71. Create pages from MySQL database
  72. How to insert dash (-) into database using wpdb and new_to_publish hook?
  73. MySQL: How to change url in posts from xxx.com to yyy.org?
  74. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  75. Upgrade DB Loop – WordPress DB Version Conflict
  76. WordPress & MySQL , problem with use many array in meta_query
  77. Button writing to MYSQL database
  78. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  79. MySQL ‘duplicate entry’ error
  80. WordPress Dutch characters encoding problem
  81. How to show result of sql query in a page?
  82. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  83. How do I insert content of various MySQL fields in post?
  84. Select latest 2 articles, but only from given category
  85. CONCAT_WS in custom sql query
  86. Query does not filter duplicate _sku numbers
  87. Ordering topics by most replies in X days using MYSQL statement
  88. MySQL Select within WP Page template
  89. wp_postmeta – lot of meta fields
  90. Running WordPress from MySQL Cluster with HAPRoxy
  91. Delete posts with word count less than x number of words
  92. MySQL: get post_tag items that are tags (not SEO keywords)
  93. $wpdb->get_var returns 0
  94. cannot log in to the mysql server (wamp and wordpress)
  95. SQL command to export post_content from wp_posts using phpMyAdmin
  96. remove wordpress post links
  97. SQL get last entry of a specific gravity form
  98. mysqldump to a tar.gz
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?
tech