mysql Failed to read auto-increment value from storage engine

by

I had the same error but in my case I had about 1.5k records in the table.
I fixed it by resetting the AUTO INCREMEN like that:

ALTER TABLE `table_name`  AUTO_INCREMENT = 1

More Related Contents:

  1. How to insert data to MySQL with auto-incremented column(field)?
  2. How does MySQL Auto Increment work?
  3. How to reuse auto_increment values? [duplicate]
  4. Reorder / reset auto increment primary key
  5. MySQL Trigger after update only if row has changed
  6. MySQL Query to select data from last week?
  7. Select last N rows from MySQL
  8. Difference Between Schema / Database in MySQL
  9. How can I modify the size of column in a MySQL table?
  10. MySQL InnoDB foreign key between different databases
  11. How to design a multi tenant mysql database
  12. SQL Order By Count
  13. Replace Into Query Syntax
  14. What resources exist for Database performance-tuning? [closed]
  15. How to connect to MySQL from the command line
  16. Remote connect to clearDB heroku database
  17. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  18. MySQL foreign key to allow NULL?
  19. How to schedule a stored procedure in MySQL
  20. What’s the best way to migrate a Django DB from SQLite to MySQL?
  21. How to get multiple records against one record based on relation?
  22. What are the differences between the BLOB and TEXT datatypes in MySQL?
  23. What is the best way to store media files on a database?
  24. Native JSON support in MYSQL 5.7 : what are the pros and cons of JSON data type in MYSQL?
  25. Foreign key constraints: When to use ON UPDATE and ON DELETE
  26. How to use a user variables in MySQL LIKE clause?
  27. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  28. How to Get True Size of MySQL Database?
  29. MySQL: Computed Column
  30. How do I make a MySQL database run completely in memory?

Leave a Comment