Title: Check the status of an import
Author: WordPress VIP Documentation
Published: August 31, 2023
Last modified: August 8, 2024

---

 1. [Databases](https://docs.wpvip.com/databases/)
 2. [Import database files](https://docs.wpvip.com/databases/import/)
 3. Check the status of an import

#  Check the status of an import

Check the status of a currently running import with the VIP-CLI command `[vip import sql status](https://docs.wpvip.com/vip-cli/commands/import/sql/status/)`
command.

If an import is _not_ currently running, the `vip import sql status` command will
output the status for the import that ran most recently. The timestamp of a requested
import and the user who triggered it can be reviewed in [the Audit Log in the VIP Dashboard](https://docs.wpvip.com/vip-dashboard/audit-log/).

## Command output

Output from the `status` command lists the series of steps executed during an import,
and displays a progress indicator for each step:

 * Pending: `○`
 * Success: `✓`
 * Failed: `✕`

An overall status report on the import process appears below the listed import steps.
The `Status:` field will display either `Running`, `Success` or `Failed`.

    ```wp-block-preformatted
    $ vip @example-app.production import sql status
    =============================================================
    Checking the SQL import status for your environment...
    ✓ Performing Search and Replace
    ✓ Uploading file
    ✓ Queueing Import
    ✓ Import preflights
    ✓ Downloading file from s3
    ✓ Uncompressing gzip
    ✓ Checking md5 hashes
    ✓ Backup db
    ✓ Importing db
    ✓ Validating db
    ✓ Update wp blogs table
    ✓ Update primary domain

    =============================================================
    Status: Success ✓ imported data should be visible on your site example-app.go-vip.net.
    Site: example-app (PRODUCTION)
    SQL Import Started: 07/01/2022, 1:14:54 pm (2022-01-07T02:14:54.000Z)
    SQL Import Completed: 07/01/2022, 1:19:31 pm (2022-01-07T02:19:31.000Z)
    =============================================================
    ```

## Import steps and the operations performed

| **Import step ** | **Operation performed** | 
| `Performing Search and Replace` | The search and replace operation(s) running on the file if a [search and replace](https://docs.wpvip.com/databases/import/#h-use-search-and-replace-to-update-domain-name-values) was specified in the import command. | 
| `Uploading file` | File compression and uploading to S3. | 
| `Queueing Import` | Queueing the import job in the system. | 
| `Import preflights` | Preparing the import job is in the system. | 
| `Downloading file from s3` | Downloading the file from S3. | 
| `Uncompressing gzip` | Uncompressing the file. | 
| `Checking md5 hashes` | Validating the integrity of the file and its data. | 
| `Backup db` | Creating a backup of the current state of the database. | 
| `Importing db`** | Importing the SQL file to the site. | 
| `Validating db` | Validating the post-import state of the database with the imported data. | 
| `Update wp blogs table` | Updating the [wp_blogs](https://codex.wordpress.org/Database_Description#Table:_wp_blogs) table: For a [WordPress multisite](https://docs.wpvip.com/multisites/) environment, this is the database table that identifies a site in its network. | 
| `Update primary domain` | Updating the [primary domain](https://docs.wpvip.com/primary-domain/): For a [WordPress multisite](https://docs.wpvip.com/multisites/) environment, if the process determines that [the `wp_site` table](https://codex.wordpress.org/Database_Description#Table:_wp_site) of the import has a different domain set in the first row than the primary domain that is assigned to the main site (ID 1) or the environment. |

**If an import fails at the `Importing db` step:

 * An [unlaunched](https://docs.wpvip.com/unlaunched/) environment’s database automatically
   rolls back to the backup taken prior to the import job.
 * A [launched](https://docs.wpvip.com/launched/) environment will be locked against
   any additional import attempts and needs to be [reset by VIP Support](https://docs.wpvip.com/vip-support/)
   in order for a new import to be attempted.

Failures can occur due to an invalid SQL file, or if there is an error present in
the file. If the import fails, the `Restore db` step is returned in the status output.

Last updated: August 08, 2024