Search 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-replace
Perform Search and Replace on the specified SQL file.
-s, --skip-validate
Do not perform pre-upload file validation. If unsupported entries are present, the import is likely to fail.
-v, --version
Output 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
Argument
Description
-a, --app=<app>
Specify the app
-d, --debug
Activate debug output
-e, --env=<env>
Specify the environment
-h, --help
Output the help for the (sub)command
-v, --version
Output the version number
-y, --yes
Run the command in production without a confirmation prompt