Purge the MySQL database

Note   This procedure is only necessary on upgraded installations, not on new installations.

When you upgrade an B2Bi installation that uses a MySQL database, before you use the database, complete the following procedure:

  1. Run the following command from the MySQL prompt:
  2. PURGE BINARY LOGS BEFORE '2016-01-01';
  3. Where the date you enter is a date in the future.
  4. Go to MySQL_install_directory/ (default location)
  5. Open the file my.ini in a text editor.
  6. Comment out the line:
  7. #log-bin=binlog
  8. Save the modification.

Related Links