Data Export Encoding

All SQL exports from ActiveCollab Cloud are UTF8MB4, and should be imported as such. In cases where character set encoding may not be correct after import, you should drop all the tables and import the data again. Use the command line to run these commands:

  1. # Go to directory where SQL file is
  2. cd /path/to/dir/where/sql/file/is
  3. # Connect to database
  4. mysql -u YOUR_MYSQL_USERNAME -p --default-character-set=utf8mb4 YOUR_DATABASE_NAME
  5. # Set connection encoding and import the data
  6. mysql > SET NAMES 'utf8mb4';
  7. mysql > SOURCE data.sql;