IMPORTANT, please fill the questions
We assume you are using Bitnami to deploy your application.
Which version of the application are you using?:
1.2.1 -> 4.1.1
Please choose how you got the application: Installer (Windows, Linux, macOS), cloud image (AWS, GCE, Azure, ...) or VM (VMDK, VBOX):
Have you installed any plugin or modified any configuration file?:
Describe here your question/suggestion/issue (expected and actual results):
So I'm following the current upgrade guide and managed to dump mysql and moved the sql-file to the new server.
When trying to import it, I can't run the command as listed in the guide. I have to connect first using
mysql.exe -u root -p
When trying to import it using source bitnami_redmine.sql I get the error:
**ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: 'ÿþ-'
So I have to connect to mysql with mysql.exe -u root -p --binary-mode -o. Then I try to import the sql-file again but I receive the error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
First line in the sql-file is -- MySQL dump 10.11
First non-commented line is CREATE DATABASE /*!32312 IF NOT EXISTS*/
bitnami_redmine /*!40100 DEFAULT CHARACTER SET utf8 */;
I tried commenting that, since the database already exists, but that didn't help. Any tips?
Also, the second step in the upgrading process isn't applicable since the old version does not have the folder htdocs, but first I wanted to see if it was possible to migrate the database.
I've tried checking in the web app after starting apache again if anything was migrated, but I can't see any projects or tickets.