CreateMySqlInitialLoadSettings¶
- class oci.database_migration.models.CreateMySqlInitialLoadSettings(**kwargs)¶
Bases:
objectOptional dump settings
Attributes:
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
Gets the compatibility of this CreateMySqlInitialLoadSettings.
Gets the handle_grant_errors of this CreateMySqlInitialLoadSettings.
Gets the is_consistent of this CreateMySqlInitialLoadSettings.
Gets the is_ignore_existing_objects of this CreateMySqlInitialLoadSettings.
Gets the is_tz_utc of this CreateMySqlInitialLoadSettings.
Gets the job_mode of this CreateMySqlInitialLoadSettings.
Gets the primary_key_compatibility of this CreateMySqlInitialLoadSettings.
Methods:
__init__(**kwargs)Initializes a new CreateMySqlInitialLoadSettings object with values from keyword arguments.
- HANDLE_GRANT_ERRORS_ABORT = 'ABORT'¶
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings. This constant has a value of “ABORT”
- HANDLE_GRANT_ERRORS_DROP_ACCOUNT = 'DROP_ACCOUNT'¶
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings. This constant has a value of “DROP_ACCOUNT”
- HANDLE_GRANT_ERRORS_IGNORE = 'IGNORE'¶
A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings. This constant has a value of “IGNORE”
- JOB_MODE_FULL = 'FULL'¶
A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings. This constant has a value of “FULL”
- JOB_MODE_SCHEMA = 'SCHEMA'¶
A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings. This constant has a value of “SCHEMA”
- PRIMARY_KEY_COMPATIBILITY_CREATE_INVISIBLE_PKS = 'CREATE_INVISIBLE_PKS'¶
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings. This constant has a value of “CREATE_INVISIBLE_PKS”
- PRIMARY_KEY_COMPATIBILITY_IGNORE_MISSING_PKS = 'IGNORE_MISSING_PKS'¶
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings. This constant has a value of “IGNORE_MISSING_PKS”
- PRIMARY_KEY_COMPATIBILITY_NONE = 'NONE'¶
A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings. This constant has a value of “NONE”
- __init__(**kwargs)¶
Initializes a new CreateMySqlInitialLoadSettings object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):
- Parameters
is_consistent (bool) – The value to assign to the is_consistent property of this CreateMySqlInitialLoadSettings.
is_tz_utc (bool) – The value to assign to the is_tz_utc property of this CreateMySqlInitialLoadSettings.
compatibility (list[oci.database_migration.models.CompatibilityOption]) – The value to assign to the compatibility property of this CreateMySqlInitialLoadSettings.
primary_key_compatibility (str) – The value to assign to the primary_key_compatibility property of this CreateMySqlInitialLoadSettings. Allowed values for this property are: “NONE”, “IGNORE_MISSING_PKS”, “CREATE_INVISIBLE_PKS”
is_ignore_existing_objects (bool) – The value to assign to the is_ignore_existing_objects property of this CreateMySqlInitialLoadSettings.
handle_grant_errors (str) – The value to assign to the handle_grant_errors property of this CreateMySqlInitialLoadSettings. Allowed values for this property are: “ABORT”, “DROP_ACCOUNT”, “IGNORE”
job_mode (str) – The value to assign to the job_mode property of this CreateMySqlInitialLoadSettings. Allowed values for this property are: “FULL”, “SCHEMA”
- property compatibility¶
Gets the compatibility of this CreateMySqlInitialLoadSettings. Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump output, altering the dump files as necessary.
- Returns
The compatibility of this CreateMySqlInitialLoadSettings.
- Return type
list[oci.database_migration.models.CompatibilityOption]
- property handle_grant_errors¶
Gets the handle_grant_errors of this CreateMySqlInitialLoadSettings. The action taken in the event of errors related to GRANT or REVOKE errors.
Allowed values for this property are: “ABORT”, “DROP_ACCOUNT”, “IGNORE”
- Returns
The handle_grant_errors of this CreateMySqlInitialLoadSettings.
- Return type
str
- property is_consistent¶
Gets the is_consistent of this CreateMySqlInitialLoadSettings. Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Returns
The is_consistent of this CreateMySqlInitialLoadSettings.
- Return type
bool
- property is_ignore_existing_objects¶
Gets the is_ignore_existing_objects of this CreateMySqlInitialLoadSettings. Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.
- Returns
The is_ignore_existing_objects of this CreateMySqlInitialLoadSettings.
- Return type
bool
- property is_tz_utc¶
Gets the is_tz_utc of this CreateMySqlInitialLoadSettings. Include a statement at the start of the dump to set the time zone to UTC.
- Returns
The is_tz_utc of this CreateMySqlInitialLoadSettings.
- Return type
bool
- property job_mode¶
Gets the job_mode of this CreateMySqlInitialLoadSettings. MySql Job Mode
Allowed values for this property are: “FULL”, “SCHEMA”
- Returns
The job_mode of this CreateMySqlInitialLoadSettings.
- Return type
str
- property primary_key_compatibility¶
Gets the primary_key_compatibility of this CreateMySqlInitialLoadSettings. Primary key compatibility option
Allowed values for this property are: “NONE”, “IGNORE_MISSING_PKS”, “CREATE_INVISIBLE_PKS”
- Returns
The primary_key_compatibility of this CreateMySqlInitialLoadSettings.
- Return type
str