[Koha] mysqldump file restore problem

Robin Sheat robin at catalyst.net.nz
Tue Jun 16 10:52:35 NZST 2015


Foiz Ahmed schreef op ma 15-06-2015 om 00:09 [-0700]:
> I have mysqldump backup file koha.sql. i want to restore it to my new
> server by this command
> mysql -u root -p koha </home/koha/koha14062015.sql
> but shows this error
> ERROR 1064 (42000) at line 203911169: You have an error in your SQL
> syntax; check the manual that corresponds to your MySQL server version

Have a look in your SQL file, at the bottom. My guess would be that it's
an incomplete file and has been chopped off part way through.

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 473 bytes
Desc: This is a digitally signed message part
URL: <https://lists.katipo.co.nz/pipermail/koha/attachments/20150616/29041692/attachment.sig>


More information about the Koha mailing list