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.
