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 agree to ActiveCollab's Terms of Service & Privacy Policy.

Great! Just a few seconds, and you're in.

All done! Redirecting you to your account.

Continue

You're only one confirmation away from your new workspace.
Check your email, and see you soon!

We detected you already have an ActiveCollab account.

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

Sorry, we couldn't 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