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;

Can’t find your answer?

Start Your Free Trial

Enter your email to get 14 days of ActiveCollab absolutely free, without any limitations.


or

By signing up you are agreeing to the ActiveCollab Terms of Service & Privacy Policy.

Great, just a few seconds and you're in.

All done! Redirecting you to your account.

Continue

We've sent you an email to confirm that it's you.
Please check your email to complete the trial account creation.

We detected that you already have an ActiveCollab account

You can log in to an excisting account or you may start a new one

Sorry, we could not create an account for you at this moment.
Please double check your email address. If the issue still persists, please let us know by sending an email to support@activecollab.com


Try again