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 command line to run these commands:

1
2
3
4
5
6
7
8
9
# Go to directory where SQL file is
cd /path/to/dir/where/sql/file/is

# Connect to database
mysql -u YOUR_MYSQL_USERNAME -p --default-character-set=utf8mb4 YOUR_DATABASE_NAME

# Set connection encoding and import the data
mysql > SET NAMES 'utf8mb4';
mysql > SOURCE data.sql;