WordPress database import: Row size too large

The problem occurs in MySQL 5.6.20 or later, if the innodb_log_file_size in the my.ini is set too low. I changed mine to 16M and the problem went away.
Thanks to @Otto for the solution.

http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html

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. Delete all post meta except featured image
  4. MySQL Syntax Error upon restoring database from backup [closed]
  5. Set Display Name to first and last name (phpmyadmin SQL Query)
  6. Emojis getting converted to “?”
  7. Delete all post meta except featured image Using SQL
  8. Connection refused on locahost after importing database?
  9. Changing root password in PHPMyAdmin for WordPress Database when going live
  10. Can’t update WordFence Options, clear data manually
  11. Files on Localhost, Database on Server
  12. phpMyAdmin error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’
  13. Installing local to live WP into subdirectory
  14. DB prefix not updating
  15. I wanted to Know that how can I give ingore to 0000-00-00 in my config file
  16. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  17. Featured image from custom to WordPress database
  18. Missing latest posts and options after DB migration via phpMyAdmin
  19. Check if a database is well installed
  20. Importing Concrete5 content to WordPress
  21. Deleting WordPress posts and media files based on author via MYSQL database
  22. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  23. MySQL SELECT increment counter
  24. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  25. How to create a foreign key in phpmyadmin
  26. Using wpdb to connect to a separate database
  27. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  28. WordPress Database lost auto increment
  29. wpdb->insert multiple record at once
  30. Restoring WordPress posts from database only
  31. Slow wp_term_relationships query
  32. How to use “TRUNCATE TABLE” MySQL statement?
  33. Importing posts from old website to new conflicting post ID’s?
  34. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  35. When importing database, it shows error
  36. WordPress for a very large website
  37. What are conventions about the schema of the $table_prefix
  38. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  39. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  40. Is deleting orphaned wp_options entries safe?
  41. How to solve slow WordPress site caused by attachment_metadata
  42. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  43. WooCommerce – Query for ordered products
  44. Large database causes slow load
  45. Import 10,000 Users into WordPress WITH a specific ID for each user
  46. Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
  47. Database slowdown after update to 3.4.1
  48. Is a direct or import approach safer for migration into WordPress?
  49. Query WordPress database by registered date and role
  50. Tons of Twitter rows in my database
  51. How to insert data into MySQL database from the form created in WordPress site
  52. How to replace values in WordPress DB using phpMyAdmin
  53. Does WordPress ever need multiple databases?
  54. Why are no posts showing despite my apparently correct DB restoration?
  55. Select Multiple meta_value from WP DB; Single Query
  56. Which is more efficient? Using usermeta, or creating a new MySQL table?
  57. Is it possible to split database tables using HyperDB?
  58. What happens if I overwrite the current wp_options table with a backup from a week ago?
  59. SQL Error wp_commentmeta – incorrect table definition
  60. Import live site to local setup without access to live site
  61. phpMyAdmin displays error when importing database
  62. WordPress database error – Error in SQL syntax – I can’t identify any error?
  63. CRUD operations using WordPress database API
  64. How to Mirror WordPress database from Remote server to Local server
  65. Is MariaDB’s Aria storage engine suitable for WordPress?
  66. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  67. Merging two databases without borking it
  68. How do I query wp_options for expired transient pairs with MySQL commands?
  69. WordPress running SQL query to update database from form
  70. How to fix database error duplicate entry
  71. How do I convert a MySQL database from utf8mb4 to utf8 encoding?
  72. Query multiple tables at once?
  73. Why this query is not showing any result on wordpresss home page?
  74. Best practice to limit results in get_row()?
  75. How to migrate a database from a server to another
  76. Trouble running $wpdb->query() with last_insert_id
  77. how to encyrpt DB_PASSWORD in wp-config
  78. Moving WordPress site to new domain – database import [duplicate]
  79. Error establishing a database connection (Set-up locally)
  80. I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
  81. Is there any defects for using same database prefix in WordPress for multiple sites?
  82. How can I find user role in Mysql?
  83. I would like some help wth an SQL query to link posts with categories
  84. WordPress Database Query works in phpMyAdmin but not in the code
  85. Delete all users meta that named: user_avatar
  86. The MySQL Connection could not be established., before it was joomla but i have change it into worpress
  87. How to retrieve user data based on role using SQL?
  88. spambot registering without providing email or password, bypassing registration process
  89. Possible to restore wordpress database from mysql56 and sqlite files?
  90. Widgets with *internal* links do not display after database migration
  91. How do i get value from wp_postmeta?
  92. Options table – where does my values go?
  93. “MySQL server has gone away” since update to 3.8
  94. featured image not showing up with mysql_connect
  95. Print output of Table Creation
  96. why you don’t Implement PDO for access every thing to database
  97. SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
  98. After Import: Insert “Use” Statement in Database
  99. SQL errors when querying for something with apostrophes
  100. Naming conventions for database tables