Redmine

Hello everyone,

at the moment we working with a redmin 0.8.2 stack. The admin would like to work with newst version (1.2). So we downloaded the newst stack and running the vm via hyper-v 2012 server. I did a backup of the files directory & config/email.yml. And a dump of the mysql db with this command:

$ mysqldump -u root -p bitnami_redmine > redmine_backup.sql

Then I packed everything in an archive together and sent it to the new server.
Now when I start the script with

$ sudo ./ue_redmine

to enter the bash-4.2. After that I try to restore the mysql dump file with this command:

$ mysql -u root -p bitnami_redmine < redmine_backup.sql

But everytime I get this error message:

bash-4.2# mysql -u root -p bitnami_redmine < redmine_backup.sql
Enter password:
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
ERROR 1064 (42000) at line 1: 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 '/opt/redmine-0.8.1-2/mysql/bin/mysql.bin Ver 14.12 Distrib 5.0.45, for pc-linux' at line 1
bash-4.2#

I checked the mysql version with the command mysql --version.

bash-4.2# mysql --version
/opt/bitnami/mysql/bin/mysql.bin Ver 14.14 Distrib 5.5.28, for linux2.6 (x86_64) using readline 5.1

I opened the file with the editor nano and changed the first line in

/opt/bitnami/mysql/bin/mysql.bin Ver 14.14 Distrib 5.5.28, for linux2.6 (x86_64' at line 1

and tried a new restore of the mysql db but the error is still there:

bash-4.2# mysql -u root -p bitnami_redmine < redmine_backupV2.sql
Enter password:
? (\?) Synonym for `help'.
clear (\c) Clear the current input statement.
connect (\r) Reconnect to the server. Optional arguments are db and host.
delimiter (\d) Set statement delimiter.
edit (\e) Edit command with $EDITOR.
ego (\G) Send command to mysql server, display result vertically.
exit (\q) Exit mysql. Same as quit.
go (\g) Send command to mysql server.
help (\h) Display this help.
nopager (\n) Disable pager, print to stdout.
notee (\t) Don't write into outfile.
pager (\P) Set PAGER [to_pager]. Print the query results via PAGER.
print (\p) Print current command.
prompt (\R) Change your mysql prompt.
quit (\q) Quit mysql.
rehash (\#) Rebuild completion hash.
source (\.) Execute an SQL script file. Takes a file name as an argument.
status (\s) Get status information from the server.
system (\!) Execute a system shell command.
tee (\T) Set outfile [to_outfile]. Append everything into given outfile.
use (\u) Use another database. Takes database name as argument.
charset (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
warnings (\W) Show warnings after every statement.
nowarning (\w) Don't show warnings after every statement.
ERROR 1064 (42000) at line 1: 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 '/opt/bitnami/mysql/bin/mysql.bin Ver 14.14 Distrib 5.5.28, for linux2.6 (x86_64' at line 1

Maybe someone can help me to fix the error.

Regards Patrick