So what version of mysql are you running? Or are you connecting as a
user without SUPER permissions?
Bret Baptist wrote:
On Saturday 28 February 2004 4:05 am, Paul J Stevens wrote:
I use mysqldump --opt dbmail, but I guess it's a matter of taste.
However, remember to execute:
SET FOREIGN_KEY_CHECKS=0;
SET SQL_LOG_OFF=1;
SET SQL_LOG_UPDATE=0;
before you start loading such a backup file. Esp if it's big.
So if dbmail.preload.mysql contains the previous statements,
mysql -e dbmail.preload.mysql dbmail < backup/dbmail.mysql
This command:
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 mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
