MySqlInitialLoadSettings¶

class oci.database_migration.models.MySqlInitialLoadSettings(**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 MySqlInitialLoadSettings.
`HANDLE_GRANT_ERRORS_DROP_ACCOUNT`	A constant which can be used with the handle_grant_errors property of a MySqlInitialLoadSettings.
`HANDLE_GRANT_ERRORS_IGNORE`	A constant which can be used with the handle_grant_errors property of a MySqlInitialLoadSettings.
`JOB_MODE_FULL`	A constant which can be used with the job_mode property of a MySqlInitialLoadSettings.
`JOB_MODE_SCHEMA`	A constant which can be used with the job_mode property of a MySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_CREATE_INVISIBLE_PKS`	A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_IGNORE_MISSING_PKS`	A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
`PRIMARY_KEY_COMPATIBILITY_NONE`	A constant which can be used with the primary_key_compatibility property of a MySqlInitialLoadSettings.
`compatibility`	Gets the compatibility of this MySqlInitialLoadSettings.
`handle_grant_errors`	Gets the handle_grant_errors of this MySqlInitialLoadSettings.
`is_consistent`	Gets the is_consistent of this MySqlInitialLoadSettings.
`is_ignore_existing_objects`	Gets the is_ignore_existing_objects of this MySqlInitialLoadSettings.
`is_tz_utc`	Gets the is_tz_utc of this MySqlInitialLoadSettings.
`job_mode`	[Required] Gets the job_mode of this MySqlInitialLoadSettings.
`primary_key_compatibility`	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’.

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]

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

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

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

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

job_mode¶

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

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