Announcement

Collapse
No announcement yet.

Error in SQL File and Can't Restore via SSH

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error in SQL File and Can't Restore via SSH

    Hello,
    I am restoring to a new server.
    I run this command via SSH/Telnet

    mysql -u dbusername -p databasename < /path/to/backupname.sql

    Of course I changed user and database names to my own.

    But when I running a few seconds later there shows this line and stoped.

    ERROR 1034 (HY000) at line 2843: 22 when fixing table

    I asked my friends they told me there is some command that it DOES NOT STOP WHEN THERE IS AN ERROR

    Please help me. Thank you
    Vui Ve Club - www.vuiveclub.net

  • #2
    What is on line 2843 and how was the backup made?
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      I run this command for backup
      mysqldump --opt -Q -u user -p data > /home/public_html/backup.sql
      Vui Ve Club - www.vuiveclub.net

      Comment


      • #4
        And what is on line 2843?
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          I dont know, I cant open that sql file to see it.
          I know there is a command to continue restore without stoping when the file has an error.
          mysql somethinghere -u dbusername -p databasename < /path/to/backupname.sql
          Vui Ve Club - www.vuiveclub.net

          Comment


          • #6
            Use: -f
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...
            X