Professional Web Applications Themes

mysqldump restore fails: Error 10167 - MySQL

Removed by Administrator...

  1. Moderated Post

    Default mysqldump restore fails: Error 10167

    Removed by Administrator
    emwiel@gmail.com Guest
    Moderated Post

  2. #2

    Default Re: mysqldump restore fails: Error 10167

    Correction: That's error 1067, not 10167! Sorry about that!

    emwiel@gmail.com Guest

  3. #3

    Default Re: mysqldump restore fails: Error 10167

    com wrote:
     

    ERROR 1067 (42000) at line 398: Invalid default value for 'date'

    That's the correct error, and easy to fix. 'CURRENT_TIMESTAMP' should not
    be in quotes. MySQL thinks you're trying to put the string
    'CURRENT_TIMESTAMP' into a date field, which won't work. See

    "http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html"

    John Nagle


    John Guest

  4. #4

    Default Re: mysqldump restore fails: Error 10167

    On Apr 24, 9:31 pm, John Nagle <com> wrote: 

    Dear John,

    thank you very much. I removed the quotes and it worked.
    I just wonder that mysqldump put CURRENT_TIMESTAMP in the first place.
    Is this a wrong behaviour, fixed with later releases, or forced by a
    parameter I used, or something else? Would be glad if I could avoid
    the wrong output, instead of using sed to strip the quotes.
    Thanks anyway for helping me out!

    EM

    emwiel@gmail.com Guest

Similar Threads

  1. Backup & restore MySQL, not using mysqldump
    By Jerry T in forum PHP Development
    Replies: 2
    Last Post: November 15th, 09:49 PM
  2. Multiple stsadm restore to same machine fails
    By Tariq in forum ASP.NET Web Services
    Replies: 2
    Last Post: February 23rd, 03:08 AM
  3. Linux onbar restore fails (IDS9.4)
    By David Stes in forum Informix
    Replies: 1
    Last Post: July 30th, 06:49 PM
  4. mondo/mindi restore fails
    By Benedict Verheyen in forum Debian
    Replies: 4
    Last Post: July 17th, 12:20 AM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139