Skip to content

Latest commit

 

History

History
65 lines (51 loc) · 3.14 KB

kubedb_restore.md

File metadata and controls

65 lines (51 loc) · 3.14 KB
Raw

kubedb restore

Restore a sql file to a database

Synopsis

Restore a sql file to a database.

Supported Databases: postgres, mariadb, mongodb, meilisearch

File Path:

  • Raw sql file. Typically with a ".sql" file extension
  • Gzipped sql file. Typically with a ".sql.gz" file extension
  • For Postgres: custom dump file. Typically with a ".dmp" file extension

Cloud Download:

  • Use "s3://" for S3 and "gs://" for GCS.
  • Cloud config is loaded from the environment (similar to the aws and gcloud tools).
kubedb restore filename [flags]

Options

      --analyze                         Run an analyze query after restore (default true)
  -c, --clean                           Clean (drop) database objects before recreating (default true)
      --create-job                      Create a job that will run the database client (default true)
      --create-network-policy           Creates a network policy allowing the KubeDB job to talk to the database. (default true)
  -d, --dbname string                   Database name to use (default discovered)
  -f, --force                           Do not prompt before restore
  -F, --format string                   Output file format (one of gzip, custom, plain) (default "gzip")
      --halt-on-error                   Halt on error (Postgres only) (default true)
  -h, --help                            help for restore
      --job-pod-labels stringToString   Pod labels to add to the job (default [])
  -O, --no-owner                        Skip restoration of object ownership in plain-text format (default true)
      --opts string                     Additional options to pass to the database client command
  -p, --password string                 Database password (default discovered)
      --port uint16                     Database port (default discovered)
      --progress                        Enables the progress bar (default true)
  -q, --quiet                           Silence remote log output
      --remote-gzip                     Compress data over the wire. Results in lower bandwidth usage, but higher database load. May improve speed on slow connections. (default true)
  -1, --single-transaction              Restore as a single transaction (default true)
  -U, --username string                 Database username (default discovered)

Options inherited from parent commands

      --context string                 Kubernetes context name
      --dialect string                 Database dialect. (one of postgres, mariadb, mongodb, redis, meilisearch) (default discovered)
      --healthchecks-ping-url string   Notification handler URL
      --kubeconfig string              Paths to the kubeconfig file (default "$HOME/.kube/config")
      --log-format string              Log format (one of auto, color, plain, json) (default "auto")
      --log-level string               Log level (one of trace, debug, info, warn, error) (default "info")
  -n, --namespace string               Kubernetes namespace
      --pod string                     Perform detection from a pod instead of searching the namespace

SEE ALSO

  • kubedb - Painlessly work with databases in Kubernetes.