Copying tables
Using the tools copy subcommand, you can create a copy of one or more DB tables. The copy operation leaves the source table unchanged while the copy contains all the source table data.
General format of the command:
ydb [global options...] tools copy [options...]
global options: Global parameters.options: Parameters of the subcommand.
View a description of the command to copy a table:
ydb tools copy --help
Parameters of the subcommand
| Parameter name | Parameter description |
|---|---|
--timeout |
The time within which the operation should be completed on the server. |
--item <property>=<value>,... |
Operation properties. You can specify the parameter more than once to copy several tables in a single transaction. Required properties:
|
Examples
Note
The examples use the quickstart profile. To learn more, see Creating a profile to connect to a test database.
Create the backup folder in the DB:
ydb -p quickstart scheme mkdir backup
Copy the series table to a table called series-v1, the seasons table to a table called seasons-v1, and episodes to episodes-v1 in the backup folder:
ydb -p quickstart tools copy --item destination=backup/series-v1,source=series --item destination=backup/seasons-v1,source=seasons --item destination=backup/episodes-v1,source=episodes
View the listing of objects in the backup folder:
ydb -p quickstart scheme ls backup
Result:
episodes-v1 seasons-v1 series-v1