From: Reindl Harald Date: November 18 2011 12:07pm Subject: Re: Restoring failed due to Unexpected Error List-Archive: http://lists.mysql.com/mysql/226325 Message-Id: <4EC64A68.5090308@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig8BD27F5DF0877A6F2F023196" --------------enig8BD27F5DF0877A6F2F023196 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 18.11.2011 12:41, schrieb Adarsh Sharma: > But when I restore the data below error exists :- >=20 > [root@test1 hdd2-1]# gunzip < source.sql.gz | mysql test >=20 > gunzip: stdin: unexpected end of file > ERROR 1064 (42000) at line 30309: 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 '' Transitional//EN\"\n\"http://www.' at line 1 > [root@test1 hdd2-1]# sounds bad have you tried to unpck the backup manually and considered to use "mysqli= mport" but anyways, the message sounds like a damaged compressed file --------------enig8BD27F5DF0877A6F2F023196 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7GSmgACgkQhmBjz394AnngSgCeKuaC8dDYlSDnknOCTxNr5xRy uB8AnjI7yWR2JDVpjNskcJQBjZ9uJ4Xt =eopM -----END PGP SIGNATURE----- --------------enig8BD27F5DF0877A6F2F023196--