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

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”

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