Transfer DB from one OE 2013 to another OE 2013 doesn't w.

[ManfredCC]

I made the update from Openemm 2012 to 2013 via the web-interface. The update was done well and the machine is running without any problems.

But now I want to switch from CentOS 6.3 32bit with graphical interface to CentOS without any graphical interface.

When i make a dump of the "old" mysql database and want to re-import it to the new machine the import stops with

"ERROR 1064 (4200) at line 234: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server for the right syntax to use near ' ' at line 1"

???

Thanks!

PS: is it enough to copy /var/lib/mysql/openemm to the new machine?

PPS: Transfer means export from one OpenEMM-2013-Server to another OpenEMM-2013-Server. Both based on CentOS

[maschoff]

Did you use

Code: Select all

mysqldump -aCceQx --hex-blob -u root -p -r /home/openemm/db_dump.sql openemm

to create the dump file?

[ManfredCC]

Yes...exactly as written in the instructions

[maschoff]

Are the MySQL versions on both machines any different? What does line 234 in your dump file show?

[ManfredCC]

Yes, MySQL-Version on both machines ist

14.14 5.1.67.

As soon as i'm sitting at my test server i'll give you the exact content of the concerned line.

[maschoff]

And you should check your dump file with "file" to make sure it is not recognized as a weird format.

[ManfredCC]

file openemm.sql UTF-8 Unicode text, with very long lines

[maschoff]

That is ok.

[ManfredCC]

Sorry for wasting your time...

It was a corrupt openemm-database. Exporting a corrupt database leads to a nonworking import