Migration of wordpress database from mariadb 10.0.20 to 5.5.50

This looks like a Foreign Key issue.

When you use PHPMyAdmin to create the sql dump, try using the custom settings to disable Foreign Key checks.

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL string replace
  4. MySQL error 2006: mysql server has gone away
  5. Which MySQL data type to use for storing boolean values
  6. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  7. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  8. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  9. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  10. What is the definition of cardinality in SQL
  11. How to restart remote MySQL server running on Ubuntu linux?
  12. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  13. what does “/index.php?admin/admin_dashboard” in my url mean
  14. How to join two tables by multiple columns in SQL?
  15. How to get size of mysql database?
  16. Selecting data from two different tables without using joins
  17. SQL – Update multiple records in one query
  18. Difference between VARCHAR and TEXT in MySQL
  19. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  20. MySQL: Invalid use of group function
  21. mysqladmin: connect to server at ‘localhost’ failed
  22. mysql update multiple columns with same now()
  23. Usage of MySQL’s “IF EXISTS”
  24. Simple Random Samples from a Sql database
  25. What does SQL clause “GROUP BY 1” mean?
  26. LAST_INSERT_ID() MySQL
  27. Generating a random & unique 8 character string using MySQL
  28. MySQL > Table doesn’t exist. But it does (or it should)
  29. SQL select only rows with max value on a column
  30. Trying to perform MINUS operation in MySQL
  31. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  32. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  33. How to create a foreign key in phpmyadmin
  34. Can’t create test file lower test start server mysql
  35. MySQL delete multiple rows in one query conditions unique to each row
  36. Create boolean column in MySQL with false as default value?
  37. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  38. Is there a naming convention for MySQL?
  39. CAST to DECIMAL in MySQL
  40. Failed to Connect to MySQL at localhost:3306 with user root
  41. How do you properly prepare a %LIKE% SQL statement?
  42. Set page template for all pages?
  43. Optimize Multiple Taxonomy Term MySQL Query?
  44. What specific database privileges does WordPress need?
  45. Using source control with WordPress
  46. SQL query to update post_date (one post = one single date & time)
  47. My WordPress site always displays a cached version of its homepage
  48. How to copy post titles to post slug in phpmyadmin
  49. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  50. Proper way to work with wpdb to get user’s firstname
  51. How to change post format from Aside to Image for all posts?
  52. How to add and SQL query of posts only published
  53. Slow Mysql Queries
  54. Database: Custom table: sprintf value for DateTime column
  55. What is the most secure way to set up the MySQL user in WPMU?
  56. Find duplicate posts with same slug and author
  57. WP_USE_EXT_MYSQL
  58. writing inner join in wpdb
  59. Distinction on meta value on pre_get_posts
  60. How to get data from WordPress site sql file
  61. WordPress with php5-fpm and nginx
  62. MySQL Rank & $wpdb
  63. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  64. WordPress post_status is future, manually added
  65. How are multiple WordPress WPDB queries handled?
  66. Regarding “Insert query error” in wordpress
  67. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  68. WordPress plugin overloading with tmp tables
  69. Site not responding error – taking long to load [closed]
  70. Copyright: Get first and last date of post type
  71. WordPress(wpdb class) and mysql stored procedures
  72. WordPress plugins for database queries
  73. WordPress doesn’t display accents after migration
  74. Replace a character in all post titles and slugs
  75. Understanding custom php that reads from WP MYSQL
  76. $wpdb->get_var multiple queries in one database check
  77. List users with the most posts in the last 30 days
  78. Way to extract wordpress data from folder backup
  79. WordPress $wpdb no result
  80. Data is not constatntly loading from custom wordpress table
  81. Mysql Server keeps crashing
  82. How to search usermeta table
  83. How to add virtual column in wpdb get_result statement
  84. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  85. I want to share local developement and staging DB — Is this very smart or very stupid?
  86. Extract all users along with yoast metadata description
  87. WordPress asks to install, but is already installed?
  88. Mysql Error in querying form entries in Gravity Form plugin
  89. Deleting a table row through query
  90. An SQL query to find orphaned image attachments and their meta
  91. Saving custom term value to the database in new table
  92. MySQL errors after a WordPress clone
  93. `#1215 – Cannot add foreign key constraint
  94. How to restore: Database intact but folders deleted
  95. XML RPC post produces immediate revision with odd post_date_gmt
  96. MYSQL Join on meta key value?
  97. Complicated MySQL Query
  98. problem with quotes on new post
  99. InnoDB: Error: log file ./ib_logfile0 is of different size
  100. Postgres equivalent to MySQL’s \G?
tech