Mysql – Failed to read auto-increment value from storage engine, Error Number: 1467

MySQL

When inserting data in mysql i get this error:

Error Number: 1467
Failed to read auto-increment value from storage engine

I don't now how to solve this issue please any help will be appreciated.

Best Answer

After some searching i found the answer and it solved my problem.

run this sql query it will fix the problem

 ALTER TABLE `YOUR_TABLE`  AUTO_INCREMENT =1

Related Solutions

Mysql – thesql Failed to read auto-increment value from storage engine

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

Mysql – 1030 Got error 28 from storage engine

Mysql error "28 from storage engine" - means "not enough disk space".

To show disc space use command below.

myServer# df -h

Results must be like this.

Filesystem    Size    Used   Avail Capacity  Mounted on
/dev/vdisk     13G     13G     46M   100%    /
devfs         1.0k    1.0k      0B   100%    /dev

Best Answer

Related Solutions

Mysql – thesql Failed to read auto-increment value from storage engine

Mysql – 1030 Got error 28 from storage engine

Related Topic