Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    17

    Unanswered: data restore problem

    Hi while I am restoring the database am getting the following errors.

    [root@ip-10-130-153-251 attano]# mysql -u root -p attanotemp -f <attanocha.sql
    Enter password:
    ERROR 1062 (23000) at line 24: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 25: Duplicate entry '15712' for key 1
    ERROR 1062 (23000) at line 26: Duplicate entry '30147' for key 1
    ERROR 1062 (23000) at line 27: Duplicate entry '44283' for key 1
    ERROR 1062 (23000) at line 37: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 47: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 67: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 77: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 87: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 97: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 107: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 117: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 136: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 155: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 165: Duplicate entry '3479' for key 1
    ERROR 1062 (23000) at line 166: Duplicate entry '19301' for key 1
    ERROR 1062 (23000) at line 167: Duplicate entry '36764' for key 1
    ERROR 1062 (23000) at line 168: Duplicate entry '54150' for key 1
    ERROR 1062 (23000) at line 178: Duplicate entry '4909' for key 1
    ERROR 1062 (23000) at line 179: Duplicate entry '8208' for key 1
    ERROR 1062 (23000) at line 180: Duplicate entry '11426' for key 1
    ERROR 1062 (23000) at line 181: Duplicate entry '14427' for key 1
    ERROR 1062 (23000) at line 182: Duplicate entry '17468' for key 1
    ERROR 1062 (23000) at line 183: Duplicate entry '20516' for key 1
    ERROR 1062 (23000) at line 184: Duplicate entry '23515' for key 1
    ERROR 1062 (23000) at line 185: Duplicate entry '26511' for key 1
    ERROR 1062 (23000) at line 186: Duplicate entry '29609' for key 1
    ERROR 1062 (23000) at line 187: Duplicate entry '32514' for key 1
    ERROR 1062 (23000) at line 188: Duplicate entry '35510' for key 1
    ERROR 1062 (23000) at line 189: Duplicate entry '38547' for key 1
    ERROR 1062 (23000) at line 218: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 228: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 238: Duplicate entry '4946' for key 1
    ERROR 1062 (23000) at line 239: Duplicate entry '11692' for key 1
    ERROR 1062 (23000) at line 240: Duplicate entry '19404' for key 1
    ERROR 1062 (23000) at line 241: Duplicate entry '27187' for key 1
    ERROR 1062 (23000) at line 242: Duplicate entry '38258' for key 1
    ERROR 1062 (23000) at line 261: Duplicate entry '1729' for key 1
    ERROR 1062 (23000) at line 271: Duplicate entry '3523' for key 1
    ERROR 1062 (23000) at line 281: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 311: Duplicate entry '669' for key 1
    ERROR 1062 (23000) at line 321: Duplicate entry '4946' for key 1
    ERROR 1062 (23000) at line 331: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 341: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 342: Duplicate entry '293959' for key 1
    ERROR 1062 (23000) at line 343: Duplicate entry '358611' for key 1
    ERROR 1062 (23000) at line 353: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 354: Duplicate entry '3688' for key 1
    ERROR 1062 (23000) at line 364: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 374: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 384: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 394: Duplicate entry '2104' for key 1
    ERROR 1062 (23000) at line 404: Duplicate entry '1037' for key 1
    ERROR 1062 (23000) at line 442: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 452: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 462: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 472: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 482: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 492: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 502: Duplicate entry '1' for key 1
    ERROR 1062 (23000) at line 512: Duplicate entry '1' for key 1
    ERROR 1136 (21S01) at line 522: Column count doesn't match value count at row 1
    ERROR 1136 (21S01) at line 523: Column count doesn't match value count at row 1
    ERROR 1136 (21S01) at line 524: Column count doesn't match value count at row 1
    ERROR 1136 (21S01) at line 525: Column count doesn't match value count at row 1

    can any one help me please???

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by chandu123 View Post
    can any one help me please???
    i'll try

    show the first 30 lines of attanocha.sql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Was the database empty when you attempted to restore? If you are restoring into a database that already has the tables and populated with data then this will definitely be the source of your problems.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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