On Wednesday 12 May 2004 3:54 pm, Paul J Stevens wrote: > So what version of mysql are you running? Or are you connecting as a > user without SUPER permissions?
I am using MySQL 4.0.18. I am running this command as the root database user. Bret. > > 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. -- Bret Baptist Systems and Technical Support Specialist [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 x17 Web Development-Web Marketing-ISP Services ------------------------------------------ Today is the tomorrow you worried about yesterday.
