This topic describes some common scenarios that OBLOADER supports and provides the corresponding use cases.
The following table provides information about the database used in the examples.
| Database information | Example value |
|---|---|
| Cluster name | Cluster A |
| OBProxy IP address | 192.168.0.0 |
| OBProxy port number | 2883 |
| Tenant name | TenantA |
| Password of a user (with at least the real-only privilege) under the sys tenant | Passroot123 (the password of the root@sys user in this example) |
| User account (with read/write privileges) under a business tenant | userA |
| Password of the user under the business tenant | Pass123 |
| Schema name | USERA |
Import schema structures
Scenario description : Import all the schema information in /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h 192.168.0.0 -P 2883 -u userA -p Pass123 --sys-password Passroot123 -c ClusterA -t tenantA -D USERA --ddl --all -f /Users/admin/LOAD-1/
Import CSV data files
Scenario description : Import all the CSV data files in /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h 192.168.0.0 -P 2883 -u userA -p Pass123 --sys-password Passroot123 -c ClusterA -t tenantA -D USERA --csv --all -f /Users/admin/LOAD-1/
Import SQL data files
Scenario description : Import all the SQL data files in /home/admin/LOAD-1/ to the USERA schema.
Example statement :
[admin@localhost]> ./obloader -h 192.168.0.0 -P 2883 -u userA -p Pass123 --sys-password Passroot123 -c ClusterA -t tenantA -D USERA --sql --all -f /Users/admin/LOAD-1/
Full import of structures and data in lite mode
Scenario description : Import all the structures and data in /home/admin/LOAD-1/ to the USERA schema in lite mode.
Example statement :
[admin@localhost]> ./obloader -h 192.168.0.0 -P 2883 -u userA -p Pass123 -c ClusterA -t tenantA -D USERA --ddl --sql --public-cloud --all -f /Users/admin/LOAD-1/