Send reply to: "Jan Huss (www.webagency.de)" <[EMAIL PROTECTED]>
From: "Jan Huss (www.webagency.de)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: DBI and Dump-files
Date sent: Mon, 14 May 2001 15:42:44 +0200
Organization: Webagency GmbH
> Hello together,
>
> I m using DBI to connect to a mysql-dbase. Now I have to import a dump-file
> was made with mysqldump. I found no chance to import this file via DBI in
> the DB in an easy way.
>
> The only possibility I am thinking about is to read throw the textfile row
> by row and splitting the single SQL-Querys to send them to the DB step by
> step.
>
> This way is not very nice and Im looking for a better one. Can you tell me
> one?
>
Read about the LOAD DATA IN FILE statement in your mysql docs (in my
version it is chapter 7.19). There is a briefing going on here since
10 minutes which i must attend, so sorry not to able to tell you more
yet...
Bodo
[EMAIL PROTECTED]
Dr. med. Bodo Eing
Institut fuer Medizinische Mikrobiologie
Klinische Virologie
v.-Stauffenbergstr. 36
48151 Muenster
Germany
Phone: ++49 251 7793 111 Fax: ++49 251 7793-104
