Title: WordPress Database error
Last modified: January 29, 2024

---

# WordPress Database error

 *  [ovialoop](https://wordpress.org/support/users/ovialoop/)
 * (@ovialoop)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-202/)
 * Hello I have problems in crashed database “postmeta”
 * i try to repair i have this message error: 8nwnUQWB_postmeta: Can’t create new
   tempfile: ‘./db_final/8nwnUQWB_postmeta.TMD’
 * i try to repair with phpmyadmin: i have this message error: 2024-01-29T15:30:
   24.065166Z 68142 [ERROR] /usr/sbin/mysqld: Table ‘./sb_final/8nwnUQWB_postmeta’
   is marked as crashed and last (automatic?) repair failed
 * I dont have any backup.
 * Any Help
 * Thanks,

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [howdyrichard](https://wordpress.org/support/users/howdyrichard/)
 * (@howdyrichard)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-202/#post-17381788)
 * Dealing with a crashed database table can be challenging, but there are some 
   steps you can take to try and repair it. Here are some suggestions:1. **Check
   Disk Space:**
 * Make sure that there is enough disk space on your server. Lack of disk space 
   can sometimes cause issues with MySQL.2. **File Permissions:**
 * Ensure that the MySQL server has the necessary permissions to read and write 
   to the database files.3. **Check the MySQL Error Log:**
 * Look into the MySQL error log to get more details about the issue. You can find
   the MySQL error log typically in the MySQL data directory, or you can check the
   MySQL configuration file for the location.4. **Manually Repair the Table:**
 * You can try to manually repair the table using the following steps:
 *     ```wp-block-code
       REPAIR TABLE 8nwnUQWB_postmeta;
       ```
   
 * You can execute this query through the MySQL command line or phpMyAdmin.
 * 5. **Force Repair:**
 * If the above repair doesn’t work, you can try to force a repair:
 *     ```wp-block-code
       REPAIR TABLE 8nwnUQWB_postmeta USE_FRM;
       ```
   
 * 6. **Check and Repair All Tables:**
 * To check and repair all tables in a database, you can use the following queries:
 *     ```wp-block-code
       CHECK TABLE 8nwnUQWB_postmeta;
       REPAIR TABLE 8nwnUQWB_postmeta;
       ```
   
 * 7. **Use myisamchk:**
 * Another option is to use the myisamchk tool. Navigate to your MySQL data directory
   and run:
 *     ```wp-block-code
       myisamchk -r 8nwnUQWB_postmeta
       ```
   
 * Note: Before running this command, ensure that the MySQL server is stopped.8.**
   Backup Before Any Repair Attempt:**
 * Always make a backup of your database before attempting any repair operations.
   Even though you mentioned you don’t have any backup, it’s a good practice to 
   create one if possible.9. **Consider Professional Help:**
 * If none of the above solutions work, it might be time to consider seeking professional
   help. A database administrator or MySQL expert may be able to assist you in recovering
   the data.
 * Remember to proceed with caution, and if possible, consult with a database administrator
   or someone experienced with MySQL to avoid any potential data loss.
 *  Moderator [threadi](https://wordpress.org/support/users/threadi/)
 * (@threadi)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-202/#post-17381980)
 * The message indicates to me that there is a problem with the hosting system. 
   Is the storage space full? Sometimes the storage space of the database is separated
   from the files. Your hoster’s support team should be able to help you with this.
 * I would also recommend contacting your hoster’s support for a backup. Many will
   create backups for you that you could use. As the affected table is a central
   WordPress database table, you will probably not be able to proceed without a 
   backup.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘WordPress Database error’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 3 replies
 * 3 participants
 * Last reply from: [threadi](https://wordpress.org/support/users/threadi/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/wordpress-database-error-202/#post-17381980)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics