CreateMySqlInitialLoadSettings¶

class oci.database_migration.models.CreateMySqlInitialLoadSettings(**kwargs)¶

Bases: object

Optional dump settings

Attributes

`HANDLE_GRANT_ERRORS_ABORT`	A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
`HANDLE_GRANT_ERRORS_DROP_ACCOUNT`	A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
`HANDLE_GRANT_ERRORS_IGNORE`	A constant which can be used with the handle_grant_errors property of a CreateMySqlInitialLoadSettings.
`JOB_MODE_FULL`	A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings.
`JOB_MODE_SCHEMA`	A constant which can be used with the job_mode property of a CreateMySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_CREATE_INVISIBLE_PKS`	A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_IGNORE_MISSING_PKS`	A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_NONE`	A constant which can be used with the primary_key_compatibility property of a CreateMySqlInitialLoadSettings.
`compatibility`	Gets the compatibility of this CreateMySqlInitialLoadSettings.
`handle_grant_errors`	Gets the handle_grant_errors of this CreateMySqlInitialLoadSettings.
`is_consistent`	Gets the is_consistent of this CreateMySqlInitialLoadSettings.
`is_ignore_existing_objects`	Gets the is_ignore_existing_objects of this CreateMySqlInitialLoadSettings.
`is_tz_utc`	Gets the is_tz_utc of this CreateMySqlInitialLoadSettings.
`job_mode`	[Required] Gets the job_mode of this CreateMySqlInitialLoadSettings.
`primary_key_compatibility`	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”

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]

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

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

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

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

job_mode¶

[Required] 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

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