My these database tables are corrupt, how can I fix them

  • Resolved sachin0a1

    (@sachin0a1)


    4 years, 4 months ago

    wp_users: Table ‘umtj1577_dbnewwcos.wp_users’ doesn’t exist
    wp_posts: Table ‘umtj1577_dbnewwcos.wp_posts’ doesn’t exist
    wp_comments: Table ‘umtj1577_dbnewwcos.wp_comments’ doesn’t exist
    wp_links: Table ‘umtj1577_dbnewwcos.wp_links’ doesn’t exist
    wp_terms: Table ‘umtj1577_dbnewwcos.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘umtj1577_dbnewwcos.wp_term_taxonomy’ doesn’t exist
    wp_termmeta: Table ‘umtj1577_dbnewwcos.wp_termmeta’ doesn’t exist

    WordPress repair says that these database tables could not be repaired, please help, How can I fix this situation. I appreciate your help.

Viewing 15 replies - 1 through 15 (of 16 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Try repairing theme with PHPMYADMIN: https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

    Thread Starter sachin0a1

    (@sachin0a1)

    Hello, I had PhyMyAdmin on my site and I tried to repair these tables from PHPMyAdmin dashboard several times but It shows “The storage engine for the table doesn’t support r…” this statement for all seven tables and I know that these are advisory but My table is still not working what I need to do from here…

    I appreciate any help from you, thank you very much for your reply…

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    That’s just a notice, not a problem. That’s normal for InnoDB. If, after attempting to repair via PHPMYADMIN, the tables are still corrupt, you’ll need to restore the database from a pre-crash backup.

    Do you have any backups? If not, see if your host might have one.

    Finally, once you recover, make sure YOU make frequent, regular, automatic backups of your files and database. I like the plugin “backwpup” for that.

    Thread Starter sachin0a1

    (@sachin0a1)

    Hello Senior, I have a backup of the database of my site, however, recently I have migrated my site to digital ocean and My question is that “I have a database “unmtj1577_dbnea” and “WordPress” section(in which my 7 DB tables locate those are corrupted) on my left of Phpmyadmin, If I am restoring my backup then I think I need to first delete my database umtj1577_dbnea and then add or create a new database with the backup database that I have.

    Is it right? if not please tell the right way to restore database, when I have database already, and please tell me about the WordPress section which contains wp_users and others.

    Thank you again for your valuable time.

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Just go ahead and restore the database. The import (via PHPMYADMIN) will drop the existing tables and replace them with the ones from the backup.

    Thread Starter sachin0a1

    (@sachin0a1)

    I did same but it shows an error #1067 – Invalid default value for ‘user_registered’

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Then your backup isn’t quite valid or is from an incompatible version of MySQL. Do you know what table his occurs in?

    Thread Starter sachin0a1

    (@sachin0a1)

    I think Wp_user

    Thread Starter sachin0a1

    (@sachin0a1)

    there is a screenshot Error Screen

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Make a copy of the backup and edit it. Find where the default value is set for that field in wp_users and change the default value to 0000-00-00 00:00:00/

    See https://i.imgur.com/47N8hQD.png

    Thread Starter sachin0a1

    (@sachin0a1)

    I need to make a copy of the database back up what I have, then I need to edit it and change the value of user_registered to 0000-00-00 00:00:00 , It is right, then I important that database file?

    Thread Starter sachin0a1

    (@sachin0a1)

    Senior, You can see in thisScreen-Link screenshot that It is already 0000-00-00 00:00:00 for user_registered in wp_user table

    Thread Starter sachin0a1

    (@sachin0a1)

    hello, please help Steven, I need it…

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Edit your mysql server config file to allow zero dates. See https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_no_zero_date

    Thread Starter sachin0a1

    (@sachin0a1)

    Thank you very much, Steven, It worked and my database tables got resorted properly now, everything is working.

Viewing 15 replies - 1 through 15 (of 16 total)
  • The topic ‘My these database tables are corrupt, how can I fix them’ is closed to new replies.