473,320 Members | 2,162 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Backup problem - disaster waiting to happen

--=-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--

Jul 19 '05 #1
0 1483

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: H M Kunzmann | last post by:
--=-BvUTDNS3Oo695JSBxY/x 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...
3
by: Tim Morrison | last post by:
MSDE2000 I have an application in which I am running a TSQL command of BACKUP DATABASE and RESTORE DATABASE for the backup and restore commands for my application. For testing purposes, i did the...
1
by: Rajesh Kapur | last post by:
I have about 20 databases in a single MySQL instance running 4.0.21 on RHEL3. I have a healthy mix of MyISAM and InnoDB tables. Howerver these two types do not mix within a single database. A...
1
by: John Rajendran | last post by:
Hi there, I need to take a backup with the following scanerio in mind: At T1 I take the FULL BACK UP of the database called BACK_1_FULL.BACK in c:\ Then at T2 I would like to take only the...
4
by: manwiththeaxe.70 | last post by:
I have recently begun to migrate our DB2 UDB v7.2 enterprise databases up to DB2 UDB v8.2. One question I can't seem to understand is why would I want to run an offline backup for a database now...
3
by: Konstantin Andreev | last post by:
Hello, everybody. I've spent a lot of time reading "DB2 Information Center" and Raul Chong's book "Understanding DB2. Learning Visually with Examples", but still unable to answer this simple...
2
by: Daniel.Peaper | last post by:
Hi Everyone, I'm working on a site that is running MS SQL 2000. They perform regular backups of databases and log files and in the event of a disaster they have a second backup server. At...
4
by: Brian D | last post by:
In MS SQL 2005 when you do a Full Backup does it also backup and truncate the transaction logs or do I need to back the transaction logs up separately? Thanks. Brian
2
by: clilush | last post by:
I've been working with db2 8.2fp14 for over a year now and was wondering what is a "standard" way of doing a backup to provide 24/7 operations with disaster recovery capabilities? My thoughts were...
5
by: aj | last post by:
SQL Server SP2 9.0.3042 64-bit I recently put my first SQL Server DB in production. In the "other" database that I use (not interested in any arguments), you can indicate the desired size of...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.