Backup problem - disaster waiting to happen

[H M Kunzmann]

--=-rJZuUUeZ11SToErfnpfu
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

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 syntax. Check the =
manual that c
om:vml\"\r\nxmlns:o=3D\"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
--=20
Herbert Michael Kunzmann
Binary Chaos Magician

--=-rJZuUUeZ11SToErfnpfu
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQA/JTZX6+7+TmiwxEkRAk4fAKCGO2+DVaaqrLGnz4jpdt10ZkyR9w CgwF7V
UFMur0oNy/M+w7PIhmx3pYI=
=o85O
-----END PGP SIGNATURE-----

--=-rJZuUUeZ11SToErfnpfu--