Empresas
Empregos
  • Sobre nós
  • Soluções
    • Publicação de vagas
      Publique sua vaga e receba candidatos qualificados em 48h.
    • Avaliações de candidatos
      Mais de 500 testes técnicos e psicológicos, mais anti-fraude.
    • Headhunting
      Busca executiva personalizada do início ao fim.
    • Folha de Pagamento + EOR
      Dispersão de folha e EOR em mais de 15 países da LATAM.
  • Preços
  • Empregos

0

291
Visualizações
#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria

Created a new database but can't create new user account due to this error. Does anyone know how to fix this? I can't find any solution to fix this.

1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria

error picture

over 4 years ago · Santiago Trujillo
6 Respostas
Responde à pergunta

0

I was attempting to add a user to a new database with 'Privileges' and received this error: "#1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria"

Select mysql from the list of databases. From the Table list, tick the box beside 'db'. Scroll to the bottom of the page, in the selection box that says 'With selected' scroll down to and select 'Repair Table' then select 'Go'. Worked for me .:m

over 4 years ago · Santiago Trujillo Relatório

0

In my case above solution not worked. But the solution is similar to suggest by the @user13439511

Follow the below steps.

  1. Select "mysql" database from the list of database. enter image description here

  2. Select all tables inside "mysql" database. enter image description here

  3. Scroll down and select "Repair Table" option in combobox.

  4. Click on Go button.

Done.

over 4 years ago · Santiago Trujillo Relatório

0

In the PHPMyAdmin panel go to the MySQL database, select the DB table and from the bottom dropdown menu select the repair table option.Your error will be resolved.

over 4 years ago · Santiago Trujillo Relatório

0

In my phpMyAdmin version (5.0.4) the mysql db gets corrupted when stop and restart the MySQL server, I solved it by running the task as a service

over 4 years ago · Santiago Trujillo Relatório

0

Spent a long time trying to fix this, but the repair method wasn't working. MySQL repairs thinks it fixed all the tables, but it wasn't fixing the error (checking the tables showed they still had errors).

I did fix it by dropping and recreating the affected tables. Instructions as follows:

  1. Select the 'mysql' database
  2. Select all the tables as described in other fixes, but run a 'check tables' instead of a 'repair tables'.
  3. For tables that are broken, (mine was the mysql.db table), you need to select the table and export it. In phpmyadmin, view the table and click export.
  4. Select custom export, and check the 'Add DROP TABLE / TRIGGER statement' option, then export. Save the sql file.
  5. In the import tab, import the sql file you just created.

This drops the table and recreates it, which fixed the issues I was having.

I'm not sure why this worked, where as repairing the table didn't.

over 4 years ago · Santiago Trujillo Relatório

0

If you can't access to the structure of mysql database, just log out then try again to repaire tables of it.

over 4 years ago · Santiago Trujillo Relatório
Responde à pergunta
Encontrar trabalhos remotos

Descubra a nova forma de encontrar um emprego!

melhores empregos
Principais categorias de trabalho
Empresas
Postar vaga Preços Comercial
Jurídico
Termos e Condições Política de privacidade
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Recomende algumas ofertas para mim
Preciso de ajuda