SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Dec 2001
    Posts
    12
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem with inserting a timestamp

    Hi,

    I have dumped a table from a mysql db on a windows machine (4.0.18-nt) and want to move the table on a mysql db on a linux machine (4.0.22-standard).

    In my table, I have a column of type TIMESTAMP(10) and it seems to be giving me some trouble. In the inserts of the sql dump, the timestamps are not between quotes and for some reasons, it looks like the mysql db on Linux needs the timestamps to be between quotes otherwise, it forces the timestamps to 0000000000. So all my timestamps are forced to 0000000000 and are thus not imported properly.

    Is there a switch somewhere that I can use to solve this problem? Is it version or os related?

    Many thanks in advance.

    Stephane

  2. #2
    SitePoint Addict pentium10's Avatar
    Join Date
    Apr 2004
    Location
    Transilvania
    Posts
    208
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    export on windows machine the database with
    a) Complete inserts
    b) Extended inserts
    c) Enclose table and field names with backquotes

    use PhpMyAdmin for this kind of job!!!
    Rype :: book, do, charge, collect,
    track time, track expenses and invoice easily on the go.
    Available on Mac, Win, iPhone, WinMobile.
    http://www.rypenow.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •