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. #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.

  2. #2
    Linux User
    Join Date
    Dec 2004
    Posts
    323

Posting Permissions

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