Psarestore/Mysql issue

[mgalloway]

I am migrating a domain from 1 server to another. During the restore on the target server, I get the following error. All other mysql data for the domain is there including mailnames etc so I know the psarestore process is using mysql correctly in some parts fo the restore. The actual database is created but contains no data.

Restoring mysql database 'db1' ...ERROR 1064 at line 1: You have an error in your SQL syntax near '/usr/bin/mysqldump Ver 8.23 Distrib 3.23.58, for redhat-linux-gnu (i386)
By Igo' at line 1

Also is there a workaround to move the mysql databases manually?

Thanks...

 

[hardweb]

Stop mysql on the first server.
Stop mysql on the second server
Copy the databases you want, located in /var/lib/mysql from one server to another. There is a directory for every DB, similar with the database name.