mysql -u root -p koha < [SPACE] /home/koha/koha14062015.sql *-- Larry Letelier N.* *F: **+56 2 3205 2737* *F: **+56 9 7589 6842* 2015-06-15 4:09 GMT-03:00 Foiz Ahmed <foizahmed54@gmail.com>:

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 for the right syntax to use near 'au:Thompson, D. J., and au:Thompson, D. J., and location:GEN and au:Chandler, E.' at line 1 i am using debian 7.8 as a OS and koha3.20 as a ILS, Please give me the advise for this regards

-- View this message in context: http://koha.1045719.n5.nabble.com/mysqldump-file-restore-problem-tp5843981.h... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

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