Are you exporting/importing the DDL as well? Is the column type the same for
both tables?
What is that column type? TIMESTAMP(14)?
-Original Message-
From: Fajar Priyanto
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 4/20/04 9:16 AM
Subject: Re: error importing date
as well? Is the column type the
same
> for both tables?
> What is that column type? TIMESTAMP(14)?
>
> -Original Message-
> From: Fajar Priyanto
> To: Victor Pendleton; '[EMAIL PROTECTED] '
> Sent: 4/20/04 9:16 AM
> Subject: Re: error importing date
>
Fajar Priyanto <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> I encounter this error when importing database from one mysql server into=20
> another: the date imported is wrong. The type is timestamp.
>
> In the dump file, the date is : 0404121921, but when imported, it becomes:=
> 0004041219.
>
> Cou
the same
> for both tables?
> What is that column type? TIMESTAMP(14)?
>
> -Original Message-
> From: Fajar Priyanto
> To: Victor Pendleton; '[EMAIL PROTECTED] '
> Sent: 4/20/04 9:16 AM
> Subject: Re: error importing date
>
> Hi Victor, thanks for respon
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Victor, thanks for responding. I really need help here.
I export/import the database using mysqldump (for exporting), and the mysql
command (for importing). One thing to be noted thought, the exported sql has
correct timestamps (they're exactly t
How are you exporting/importing the data?
-Original Message-
From: Fajar Priyanto
To: [EMAIL PROTECTED]
Sent: 4/20/04 3:51 AM
Subject: error importing date
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I encounter this error when importing database from one mysql server
into
an
