Transfer DB from one OE 2013 to another OE 2013 doesn't w.
Posted: Thu Feb 28, 2013 10:22 am
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
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