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

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’.

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