Find the answer to your Linux question:
Results 1 to 2 of 2
Hello, I am currently attempting to restore a very large MySQL database (1.4GB). [root@server]# mysql --password=xxx --user=root vb < backup.sql ERROR 1060 (42S21) at line 5116: Duplicate column name 'quoteid' ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. 07-06-2008 #1
    RAH
    RAH is offline
    Just Joined!
    Join Date
    Jun 2008
    Posts
    31

    Question Restore Database

    Hello,

    I am currently attempting to restore a very large MySQL database (1.4GB).

    [root@server]# mysql --password=xxx --user=root vb < backup.sql
    ERROR 1060 (42S21) at line 5116: Duplicate column name 'quoteid'

    Is there anyway of forcing the database to restore? Basically it takes like an hour to get to this error where it halts and doesn't restore the rest of the database.

    Thanks.
    Reply With Quote Reply With Quote
  2. 07-23-2008 #2
    technossomy
    technossomy is offline
    Linux User
    Join Date
    Dec 2004
    Posts
    323
    Solved elsewhere:
    Arch Linux Forums / [SOLVED] Restore Database
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules