Hi Herbert, the -f/--force option lets you continue with the next command
Thats my $0.0.2. Best regards Nils Valentin Tokyo/Japan 2003年 7月 28日 月曜日 17:57、H M Kunzmann さんは書きました: > I use mysqldump to dump my databases to file. > I then write these files to tape. > > I was doing a test restore to a test server this weekend and found that > for my largest database, I cannot restore from this file. > > I use mysql < backup.script. > > It runs for a long time and creates most of the tables, but eventually > comes up with a syntax error and stops processing the file. > > I have two questions: > How do I get around this ? The error message is: > > .ERROR 1064 at line 78631: You have an error in your SQL syn > s:v=\"urn:schemas-microsoft-com:vml\"\r\nxmlns:o=\"u > > This data is xml data stored in one of the fields. If mysqldump created > the syntax surely it should process back in correctly ? There's no way I > can edit 2GB of incorrect entries in order to correct them. > > Secondly, how can I make the restore more fault tolerant ? If one call > fails to continue with the next one ? > > Thank > Ciao > Herbert -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]