Check the status of a currently running import with the VIP-CLI command
vip 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.
Output from the
status command lists the series of steps executed during an import, and displays a progress indicator for each step:
An overall status report on the import process appears below the listed import steps. The
Status: field will display either
$ vip @mytestsite.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 mytestsite.go-vip.net. Site: mytestsite (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
Performing Search and Replace
|The search and replace operation(s) running on the file if a search and replace was specified in the import command.
|File compression and uploading to S3.
|Queueing the import job in the system.
|Preparing the import job is in the system.
Downloading file from s3
|Downloading the file from S3.
|Uncompressing the file.
Checking md5 hashes
|Validating the integrity of the file and its data.
|Creating a backup of the current state of the database.
|Importing the SQL file to the site.
|Validating the post-import state of the database with the imported data.
Update wp blogs table
|Updating the wp_blogs table: For a WordPress multisite environment, this is the database table that identifies a site in its network.
Update primary domain
|Updating the primary domain: For a WordPress multisite environment, if the process determines that the
wp_site table 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 environment’s database automatically rolls back to the backup taken prior to the import job.
- A launched environment will be locked against any additional import attempts and needs to be reset by 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: December 22, 2023