1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Psarestore/Mysql issue

Discussion in 'Plesk for Linux - 8.x and Older' started by mgalloway, Jul 31, 2005.

  1. mgalloway

    mgalloway Guest

    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?

  2. hardweb

    hardweb Guest

    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.