Ah, silly me.

please to:

cat dbmail.preload.mysql dbmail.sql | mysql dbmail

in stead.


mysql -e dbmail.restore.preload dbmail -p < dbmail.sql

Always results in:
ERROR 1064 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 'dbmail.restore.preload' at line 1

Any hints I could work with here?  I am trying to transfer my db to a new
server...

$cat dbmail.restore.preload:
SET FOREIGN_KEY_CHECKS=0;
SET SQL_LOG_OFF=1;
SET SQL_LOG_UPDATE=0;

Bret.


should be a clean recovery procedure.



--
  ________________________________________________________________
  Paul Stevens                                         [EMAIL PROTECTED]
  NET FACILITIES GROUP                     GPG/PGP: 1024D/11F8CD31
  The Netherlands_______________________________________www.nfg.nl

Reply via email to