Find the answer to your Linux question:
Results 1 to 2 of 2
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1

    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

Posting Permissions

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