Versions Compared

Old Version 16

changes.mady.by.user Chris Welford

Saved on

compared with

New Version 17

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 you must make sure that either:

  • Your session either has the setting loglog_bin_trust_function_creators updatedsetting switched on. You can do this with the command:
Code Block
set global log_bin_trust_function_creators = 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

...