Home / server / Questions / 595278
Accepted
Witek
Asked: 2014-05-16 02:14:57 +0800 CST

How to import MySQL dump which is encoded with quoted printable?

  • 772

I got a MySQL DDL file ddl.sql which I would like to import. It starts like this:

--=20MySQL=20dump=2010.11=0A--=0A--=20Host:=20localhost=20=20=20=20=
Database:=20ww=0A--=20=
------------------------------------------------------=0A--=20Server=20=

I think it is a kind of quoted printable encoding. When I try to import this via mysql testdb < ddl.sql I get the following error:

ERROR 1064 (42000) at line 1: 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 '--=20MySQL=20dump=2010.11=0A--=0A--=20Host:=20localhost=20=20=20=20=Database:=2' at line 1

Is there a way MySQL can read this kind of files? Or do I have to convert it first? Any ideas how?

mysql

1 Answers

  1. Best Answer

    Solution was to decode the file with qprint before importing.

    • 0