Versions Compared

Old Version 15

changes.mady.by.user Chris Welford

Saved on

compared with

New Version 16

changes.mady.by.user Chris Welford

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

Some MariaDB PhixFlow migration scripts create or use privileged functions and/or procedures, and must have privileges not required by the regular PhixFlow user.

You can permanently allow functions like this to run by updating a setting in your my.cnf file. See Running non-deterministic functions in MariaDB for details. If you do not make this change, then

Specifically, one of the following must be true:

  • the migration user has SUPER privilege, or
    • the mysql global variable '

    you must make sure that either:

    • Your session either has the setting log_bin_trust_function_creators updated. You can do this with the command:
    Code Block
    set global log_bin_trust_function_creators
    ' is set to trueIf neither are true, the migration script may fail and would require manual recovery
     = 1;

    Or that the migration user has SUPER privilege.


    Code Block
    titleE.g. for MariaDB users
    cd $RELEASE/schema/sqlserver/migration/X.Y
mysql -h myServer -u myUsername -p -D myDatabase
source migrate_schema_from_x_y_z_to_X_Y_Z.sql

    ...