“Error 1064” when importing msql database after updating wordpress version to 4.2.1

It has happened to me a couple of times. This is what helped me.

  1. if you are uploading the .sql file which is compressed, try to import uncompressed .sql file.
  2. Try to export the .sql database again, this error also comes when the database wasn’t exported properly.

Related Posts:

  1. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  2. How to change collation of database, table, column?
  3. Unknown collation when I import a dump from an existing site into a development database?
  4. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  5. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  6. MySQL Error “Operand should contain 1 column”
  7. How to use MySQL DECIMAL?
  8. MySQL ERROR 1290 (HY000) –secure-file-priv option
  9. MySQL server startup error ‘The server quit without updating PID file’
  10. MySQL DROP all tables, ignoring foreign keys
  11. Setting up foreign keys in phpMyAdmin?
  12. Duplicating a MySQL table, indices, and data
  13. mysql Foreign key constraint is incorrectly formed error
  14. mysql is not recognised as an internal or external command,operable program or batch
  15. SELECT * FROM multiple tables. MySQL
  16. mysql: SOURCE error 2?
  17. How to avoid MySQL ‘Deadlock found when trying to get lock; try restarting transaction’
  18. Data truncated for column?
  19. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  20. MySQL foreach loop
  21. MySQL IF NOT NULL, then display 1, else display 0
  22. MySQL date format DD/MM/YYYY select query?
  23. MySQL Calculate Percentage
  24. Repair all tables in one go
  25. Get the new record primary key ID from MySQL insert query?
  26. #1214 – The used table type doesn’t support FULLTEXT indexes
  27. importing a CSV into phpmyadmin
  28. Failed building wheel for mysql-python
  29. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  30. Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
  31. Remove Primary Key in MySQL
  32. How to use the keyword ‘references’ in MySQL?
  33. How to get the max of two values in MySQL?
  34. select * from table where column = something or, when unavailable, column = something else
  35. Differences between utf8 and latin1
  36. mysql: connection refused when trying to connect to localhost using remote IP
  37. Error: Duplicate entry ‘0’ for key ‘PRIMARY’
  38. Why are simple updates to wp_postmeta’s “_edit_lock” so slow?
  39. What are the recommended database permissions for WordPress?
  40. Complex meta query with 3 keys
  41. How to log mysql errors from wordpress core?
  42. Fulltext search in posts sorted by relevancy
  43. wpdb Custom Meta Data with 2 conditions
  44. query to create woocommerce products from images
  45. Configure WordPress to connect to Mysql DB using SSH tunneling
  46. How to bulk delete all WordPress subscribers?
  47. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  48. Rewrite database urls
  49. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  50. Changing Table Prefix for an Existing WordPresss Site
  51. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  52. Migrating from Existing MySQL Setup to WordPress
  53. How to split the a table in database?
  54. Can I restart MySQL engine when WordPress website is live?
  55. How do I join a $wpdb query with user meta using default value if not exist?
  56. mySQL statment count of post in each category and sub category
  57. Paypal Post IPN handeling nightmare
  58. Update or insert meta key value – On Duplicate key update
  59. Connect to MySQL using Windows Authentication
  60. Is there a page length limit?
  61. WordPress tables and aliases?
  62. What’s the sql for this condition?
  63. Create a form with custom autocomplete address field and CSV import values
  64. WordPress insert query is not working : Showing no Error
  65. How to get INSERT errors from $wpdb?
  66. Copy usermeta value where ID matches in the same table
  67. Same database; different WordPress
  68. Some Post Content Does Not Show Up In DB Search
  69. How can I write a formal sql query to get data from a custom table
  70. WordPress & MySQL , problem with use many array in meta_query
  71. How can I view my site directly from WordPress dashboard?
  72. (WP List Table) How to sort by SKU and Custom Fields?
  73. Word Press and database from another server sync
  74. User set date and time from frontend doesn’t get stored into database
  75. get posts whether meta_key exists or not
  76. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  77. How to bulk delete a certain part of all wordpress posts
  78. When I add metadata, metavalue length is added in to the value in some cases
  79. Changes not being reflected on new server
  80. update_option returns false in AJAX, how to debug?
  81. Why can’t i come back to older working version of php after ugrade with error log on php 7.2 and 7.3
  82. WordPress database error Duplicate entry for key ‘slug’
  83. How do I insert content of various MySQL fields in post?
  84. MySQL – How to combine data from two tables into one?
  85. Stop my loop to register data twice
  86. `#1215 – Cannot add foreign key constraint
  87. How to restore: Database intact but folders deleted
  88. wp_postmeta – lot of meta fields
  89. XML RPC post produces immediate revision with odd post_date_gmt
  90. Woocommerce: Grab total revenue of a product over all orders
  91. MySQL: get post_tag items that are tags (not SEO keywords)
  92. $wpdb->get_var returns 0
  93. cannot log in to the mysql server (wamp and wordpress)
  94. SQL command to export post_content from wp_posts using phpMyAdmin
  95. remove wordpress post links
  96. SQL get last entry of a specific gravity form
  97. mysqldump to a tar.gz
  98. Postgres equivalent to MySQL’s \G?
  99. How to check what port mysql is running on
  100. Where is my mysql log on OS X?
tech