Database-related errors can occur during the build process due to various reasons, such as corrupted tables or missing database entries. This article provides solutions to common database issues encountered during the build process.

General Database Error or Warning

If you receive a general error or warning during the database build process, try the following solutions:

Option 1: Repair Database Tables

Repair the affected database tables to resolve corruption issues. For a complete guide on repairing tables, refer to this article.

Option 2: Switch Database Build Engines

By default, the database is built using MySQLDump. While this works on most hosting platforms, you may encounter issues on certain configurations. If MySQLDump causes errors, switch to PHP mode:

1. Go to Duplicator Lite/Pro » Settings.
2. Navigate to the Backups tab.
3. Under SQL Mode, select PHP Code.

Missing Database Table

If the build log indicates that a table does not exist in the database, you may see errors such as:

Common Error Messages

• Runtime error in database dump
• QUERY ERROR: Table ‘databasename.wp_sometable’ doesn’t exist in engine

Option 1: Repair Database Tables

Repair the missing or corrupted tables to restore database integrity. For detailed steps, refer to this article.

Option 2: Enable a Table Filter

If the issue is caused by a plugin, consider filtering out the problematic plugin’s database tables and directory before building the backup:

1. Identify the affected plugin.
2. Filter out the plugin’s database tables.
3. Exclude the plugin’s directory located at {your-website-root}/wp-content/plugins/plugin_name/.
4. Reinstall the plugin on the destination system.

If reinstalling the plugin is not an option, contact the plugin author for guidance on repairing or reinitializing the missing table.

Following these steps should help resolve most database-related build issues.