Skip to content

vip import sql [options] [command]

Import a SQL database file to your VIP Platform environment

Commands

NameDescription
statusCheck the status of the current running import

Options

ArgumentDescription
-a, --appSpecify the application
-d, --debugActivate debug output.
-e, --envSpecify the environment.
-h, --helpOutput the help menu for the (sub)command
-i, --in-placeSearch and Replace explicitly on the given input file.
-o, --output [value]Specify the replacement output file for Search and Replace (defaults to “process.stdout”).
-S, --search-replacePerform Search and Replace on the specified SQL file.
-s, --skip-validateDo not perform pre-upload file validation. If unsupported entries are present, the import is likely to fail.
-v, --versionOutput the version number.

Examples

   # Import the given SQL file to your environment.
    $ vip @mysite.develop import sql <file.sql>

   # Perform a Search and Replace, then import the replaced file to your environment.
    * Ensure there are no spaces between your search-replace parameters
    $ vip @mysite.develop import sql <file.sql> --search-replace="from,to"

   # Search and Replace on the input <file.sql>, then import the replaced file to your environment.
    $ vip @mysite.develop import sql <file.sql> --search-replace="from,to" --in-place

   # Output the performed Search and Replace to the specified output file, then import the replaced file to your environment.
* Has no effect when the `--in-place` flag is used
    $ vip @mysite.develop import sql <file.sql> --search-replace="from,to" --output="<output.sql>"

   # Check the status of the most recent import. If an import is running, this will poll until it is complete.
    $ vip @mysite.develop import sql status

Global Options

ArgumentDescription
-a, --app=<app>Specify the app
-d, --debugActivate debug output
-e, --env=<env>Specify the environment
-h, --helpOutput the help for the (sub)command
-v, --versionOutput the version number
-y, --yesRun the command in production without a confirmation prompt

Last updated: December 17, 2022