Re: perl IF DBI::errsrt
From: Xaver Biton (javier_at_t-online.de)
Date: 06/12/04
- Next message: Anno Siegel: "Re: Extracting Text"
- Previous message: blnukem: "Values From Multiple Arrays"
- In reply to: Kevin Collins: "Re: perl IF DBI::errsrt"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 12 Jun 2004 12:22:21 +0200
Kevin Collins wrote:
> In article <841xkms3lg.fsf@notvalid.se>, moller@notvalid.se wrote:
>
>>Xaver Biton <javier@t-online.de> writes:
>>
>>
>>>Hi,
>>>
>>>I'writing a program which will be used to migrate a mysql DB to
>>>another mysql DB.
>>In cases like this it's *almost* *always* better to use
>>the tools provided by the database.
>>>From webpage:
>>"The mysqldump client can be used to dump a database or a collection of
>> databases for backup or for transferring the data to another SQL server
>> (not necessarily a MySQL server). The dump will contain SQL statements
>> to create the table and/or populate the table. "
>>
>>Start reading here if interested.
>>http://dev.mysql.com/doc/mysql/en/mysqldump.html
>
Hi,
its not only a question of dumping and inserting, the big problem is
that the old DB was not normalized, the new db is normalized, so I've to
transform/process the data and insert other columnvalues, keysvalues,
names and I use a anderstandable name convention, so the best way is to
use perl for such work. I found The approach of Xho interesting, but
later I thought, that inserting the failed record in a error table its
not cleaver, because I've to create a new error table for each real
table, instead I tought that using a file in which will be written every
the message error ( row number and tablename) should be better.
what you think about?
Xaver
- Next message: Anno Siegel: "Re: Extracting Text"
- Previous message: blnukem: "Values From Multiple Arrays"
- In reply to: Kevin Collins: "Re: perl IF DBI::errsrt"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
