MySqlInitialLoadSettings¶
- class oci.database_migration.models.MySqlInitialLoadSettings(**kwargs)¶
Bases:
objectOptional dump settings
Attributes:
A constant which can be used with the handle_grant_errors property of a MySqlInitialLoadSettings.
A constant which can be used with the handle_grant_errors property of a MySqlInitialLoadSettings.
A constant which can be used with the handle_grant_errors property of a MySqlInitialLoadSettings.
A constant which can be used with the job_mode property of a MySqlInitialLoadSettings.
A constant which can be used with the job_mode property of a MySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
Gets the compatibility of this MySqlInitialLoadSettings.
Gets the handle_grant_errors of this MySqlInitialLoadSettings.
Gets the is_consistent of this MySqlInitialLoadSettings.
Gets the is_ignore_existing_objects of this MySqlInitialLoadSettings.
Gets the is_tz_utc of this MySqlInitialLoadSettings.
Gets the job_mode of this MySqlInitialLoadSettings.
Gets the primary_key_compatibility of this MySqlInitialLoadSettings.
Methods:
__init__(**kwargs)Initializes a new MySqlInitialLoadSettings 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 MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings. This constant has a value of “IGNORE”
- JOB_MODE_FULL = 'FULL'¶
A constant which can be used with the job_mode property of a MySqlInitialLoadSettings. This constant has a value of “FULL”
- JOB_MODE_SCHEMA = 'SCHEMA'¶
A constant which can be used with the job_mode property of a MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings. This constant has a value of “NONE”
- __init__(**kwargs)¶
Initializes a new MySqlInitialLoadSettings 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 MySqlInitialLoadSettings.
is_tz_utc (bool) – The value to assign to the is_tz_utc property of this MySqlInitialLoadSettings.
compatibility (list[oci.database_migration.models.CompatibilityOption]) – The value to assign to the compatibility property of this MySqlInitialLoadSettings.
primary_key_compatibility (str) – The value to assign to the primary_key_compatibility property of this MySqlInitialLoadSettings. Allowed values for this property are: “NONE”, “IGNORE_MISSING_PKS”, “CREATE_INVISIBLE_PKS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
is_ignore_existing_objects (bool) – The value to assign to the is_ignore_existing_objects property of this MySqlInitialLoadSettings.
handle_grant_errors (str) – The value to assign to the handle_grant_errors property of this MySqlInitialLoadSettings. Allowed values for this property are: “ABORT”, “DROP_ACCOUNT”, “IGNORE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
job_mode (str) – The value to assign to the job_mode property of this MySqlInitialLoadSettings. Allowed values for this property are: “FULL”, “SCHEMA”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- property compatibility¶
Gets the compatibility of this MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings.
- Return type
list[oci.database_migration.models.CompatibilityOption]
- property handle_grant_errors¶
Gets the handle_grant_errors of this MySqlInitialLoadSettings. The action taken in the event of errors related to GRANT or REVOKE errors.
Allowed values for this property are: “ABORT”, “DROP_ACCOUNT”, “IGNORE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The handle_grant_errors of this MySqlInitialLoadSettings.
- Return type
str
- property is_consistent¶
Gets the is_consistent of this MySqlInitialLoadSettings. Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.
- Returns
The is_consistent of this MySqlInitialLoadSettings.
- Return type
bool
- property is_ignore_existing_objects¶
Gets the is_ignore_existing_objects of this MySqlInitialLoadSettings. 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 MySqlInitialLoadSettings.
- Return type
bool
- property is_tz_utc¶
Gets the is_tz_utc of this MySqlInitialLoadSettings. Include a statement at the start of the dump to set the time zone to UTC.
- Returns
The is_tz_utc of this MySqlInitialLoadSettings.
- Return type
bool
- property job_mode¶
Gets the job_mode of this MySqlInitialLoadSettings. MySql Job Mode
Allowed values for this property are: “FULL”, “SCHEMA”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The job_mode of this MySqlInitialLoadSettings.
- Return type
str
- property primary_key_compatibility¶
Gets the primary_key_compatibility of this MySqlInitialLoadSettings. Primary key compatibility option
Allowed values for this property are: “NONE”, “IGNORE_MISSING_PKS”, “CREATE_INVISIBLE_PKS”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
- Returns
The primary_key_compatibility of this MySqlInitialLoadSettings.
- Return type
str