> ## Documentation Index
> Fetch the complete documentation index at: https://docs.mainwp.com/llms.txt
> Use this file to discover all available pages before exploring further.

# All child sites disappeared from my MainWP Dashboard

> Check database errors and MySQL configuration when Child Sites disappear from MainWP Dashboard, then review database repair and backup restoration options.

When all Child Sites disappear from the Manage Sites table, check for database errors and configuration issues before attempting database repair or restoring a backup. This guide covers MySQL configuration, database repair, and backup restoration options.

> [!NOTE]
>
> If your Dashboard's error log contains **Error 1104** or **MAX\_JOIN\_SIZE**, follow [Resolve MAX\_JOIN\_SIZE Errors](https://docs.mainwp.com/troubleshooting/resolve-max-join-size-errors.md) first. A database query limit can hide sites from the list even when the site records still exist.

## What You'll Learn

* Check for MySQL configuration issues
* Repair the database using WordPress built-in tools
* Repair the database using phpMyAdmin
* Restore from backup as a last resort

## Prerequisites

* FTP or file manager access to your Dashboard site
* Ability to edit wp-config.php
* cPanel or phpMyAdmin access (for database repair method)
* Recent backup (optional, for restore method)

***

## Check MySQL Configuration

Before repairing the database, verify that the **ANSI\_QUOTES** MySQL mode is not causing the issue.

**1. Check MySQL modes**

Go to **MainWP > Info > Server Information** and locate the **MySQL Modes** row.

![MainWP Server Information page showing MySQL Modes section](https://mintcdn.com/mainwp/vt3GV9YSpiQ1gEJI/images/troubleshooting/disappeared-sites-step2.png?fit=max\&auto=format\&n=vt3GV9YSpiQ1gEJI\&q=85\&s=55375555fb766a63d99d153dfcdf3ace)

**2. Verify ANSI\_QUOTES is disabled**

Confirm that **ANSI\_QUOTES** is not listed in the MySQL modes. If it is enabled, contact your hosting provider to disable it.

***

## Repair Database Using WP\_ALLOW\_REPAIR

WordPress includes a built-in database repair feature that requires minimal technical knowledge.

**1. Download wp-config.php**

Connect to your Dashboard site via FTP and download `wp-config.php` from the WordPress root folder.

**2. Add the repair constant**

Open wp-config.php in a text editor and add this line before the `if ( !defined('ABSPATH') )` line:

```php theme={null}
define( 'WP_ALLOW_REPAIR', true );
```

![wp-config.php showing WP\_ALLOW\_REPAIR constant](https://mintcdn.com/mainwp/vt3GV9YSpiQ1gEJI/images/troubleshooting/disappeared-sites-step1.png?fit=max\&auto=format\&n=vt3GV9YSpiQ1gEJI\&q=85\&s=62b7ee9073eba13c3ac2b155e76a7d9c)

**3. Upload the file**

Save the file and upload it back to your server, overwriting the existing copy.

**4. Access the repair page**

In your browser, go to:

```text theme={null}
https://yourdashboard.com/wp-admin/maint/repair.php
```

Replace `yourdashboard.com` with your actual Dashboard URL.

![WordPress Database Repair page with repair options](https://mintcdn.com/mainwp/vt3GV9YSpiQ1gEJI/images/troubleshooting/disappeared-sites-step4.png?fit=max\&auto=format\&n=vt3GV9YSpiQ1gEJI\&q=85\&s=cce4f4f329b0bf5c9f269184c5e5f007)

**5. Run the repair**

Click **Repair and Optimize Database**. This option repairs corrupted tables and optimizes performance.

**6. Verify completion**

Scroll to the bottom of the results page. You should see the message: "Repairs complete. Please remove the following line from wp-config.php to prevent this page from being used by unauthorized users."

**7. Remove the repair constant**

Edit wp-config.php again and remove the `WP_ALLOW_REPAIR` line you added. Upload the file to your server.

**8. Verify sites restored**

Go to **MainWP > Sites > Manage Sites** and confirm your child sites are visible again.

> [!WARNING]
>
> Always remove the WP\_ALLOW\_REPAIR line after repairing. Leaving it enabled allows anyone to access the repair page without authentication.

***

## Repair Database Using phpMyAdmin

If the WordPress repair method doesn't work, try repairing directly through phpMyAdmin.

**1. Open phpMyAdmin**

Log in to your hosting cPanel and open the phpMyAdmin module.

**2. Select your database**

In the left sidebar, click your WordPress database name. If you're unsure which database to select, check the `DB_NAME` value in your wp-config.php file.

**3. Select tables to repair**

If you know which table is corrupted, select only that table. Otherwise, click **Check all** to select all tables.

![phpMyAdmin interface showing table selection and Repair option](https://mintcdn.com/mainwp/vt3GV9YSpiQ1gEJI/images/troubleshooting/disappeared-sites-step3.png?fit=max\&auto=format\&n=vt3GV9YSpiQ1gEJI\&q=85\&s=a6b7a9905a212ab4f4a25cc8fc40949a)

**4. Run repair**

From the dropdown menu at the bottom, select **Repair table** and click **Go**.

**5. Verify completion**

phpMyAdmin displays the repair results. Once complete, go to your Dashboard and verify your sites are restored.

***

## Restore from Backup

If database repair doesn't resolve the issue, restore your Dashboard database from a recent backup.

**1. Access your backup**

Locate your most recent Dashboard database backup. This may be in your hosting account, a backup plugin, or an offsite backup service.

**2. Restore the database**

Use phpMyAdmin, your hosting control panel, or your backup plugin to restore the database.

**3. Verify restoration**

After restoring, log in to your Dashboard and verify your child sites are visible.

> [!NOTE]
>
> Restoring a backup may result in some data loss if changes were made after the backup date. Re-sync all sites after restoration to ensure current data.

***

## If Nothing Works

If you've tried all methods and your sites are still missing, [contact MainWP Support](https://mainwp.com/mainwp-support/) for assistance.

***

## Self-Check Checklist

* [ ] Verified ANSI\_QUOTES MySQL mode is disabled
* [ ] Attempted WordPress built-in repair
* [ ] Attempted phpMyAdmin repair (if needed)
* [ ] Restored from backup (if needed)
* [ ] Removed WP\_ALLOW\_REPAIR from wp-config.php
* [ ] Child sites visible in Manage Sites table

***

## Related Resources

* [Troubleshoot Connection Problems](https://docs.mainwp.com/troubleshooting/potential-issues.md) - Other connection issues
* [Resolve System Requirements](https://docs.mainwp.com/troubleshooting/resolve-system-requirement-issues.md) - Server configuration issues
* [Dashboard Backup Preparation](https://docs.mainwp.com/advanced/how-to-migrate-the-mainwp-dashboard.md#create-backups) - Back up the Dashboard installation and its database


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.