Versions Compared

Old Version 10

changes.mady.by.user Gary Parden

Saved on

compared with

New Version 11

changes.mady.by.user Gary Parden

Saved on

Key

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

...

MariaDB (MySQL)

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.

One Specifically, one of the following must be true:

  • the migration user must have SUPER privilege, or
  • the mysql global variable 'log_bin_trust_function_creators' must be set to true

If neither are true, the migration script may fail and would require manual recovery.


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

...