Announcement

Collapse
No announcement yet.

getting an Error error when tryin to get my host to restore one of my sites db

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

  • [Forum] getting an Error error when tryin to get my host to restore one of my sites db

    here's the error my host gets when they try to restore my other sites db,

    Code:
    ERROR 1064 (42000) at line 104: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `adminhelp`' at line 6;
    can you guys help me to fix this error so my host can restore my other sites db?

    TY!^ ^

    - - - Updated - - -

    Bump

  • #2
    When seeking troubleshooting help, it's important to provide more information, such as what you are wanting to do.

    Comment


    • #3
      Originally posted by Andy View Post
      When seeking troubleshooting help, it's important to provide more information, such as what you are wanting to do.
      Sorry, I've trying to restore my site back to the way it was before in got ****ed up, reason I'm tryin to restore it is because I meant to access the upgrade script page but incidentally ran the install script page and whipped my site completely clean but when my host tried restoring the db the guy got this db error.

      Code:
      ERROR 1064 (42000) at line 104: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `adminhelp`' at line 6;


      so can you guys help me fix that db error plz?


      Thank you!

      Sean

      Comment


      • #4
        You need to try to import your database with other options rather than shell.

        Bigdump:
        http://www.ozerov.de/bigdump.php

        MySQLDumper:
        http://www.mysqldumper.de/en/index.php

        MySQLHotxcopy:
        http://www.vbulletin.com/forum/showt...t=mysqlhotcopy


        The hosting guy should have enough experience to solve this or maybe your backup is corrupted anyway.
        Please feel free to contact me if you have any questions or concerns

        Links: vBulletin Manual - Code Documentation - FAQ - Bug Tracker - Lemon Juice
        vBulletin 5 Connect: Extensions - Articles - Features - Purchases

        Comment


        • #5
          Hi Sean,

          How was you backup created? How many posts does your forum have?

          There is the possibility that your backup might be incomplete in which case you will not be able to recover from this mistake.

          Comment


          • #6
            Originally posted by Shadow Demon View Post
            here's the error my host gets when they try to restore my other sites db,

            Code:
            ERROR 1064 (42000) at line 104: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `adminhelp`' at line 6;
            can you guys help me to fix this error so my host can restore my other sites db?

            TY!^ ^

            - - - Updated - - -

            Bump
            How is your host trying to restore your backup?

            P.s. Can you copy/paste here the code for the adminhelp table from the backup btw? Or you could try this, open up your backup sql file and then remove completely the codes that adds the adminhelp table, save the changes and give the restore another go. And when the restore is completed, re-add the adminhelp table manually in the db. You can take it structure from the mysql-schema.php file inside the install folder.

            Comment


            • #7
              For reference, this is the forum Sean is talking about (it's his brother's forum), which, before this happened, was running vBulletin 4.1.12.

              If I recall correctly, there were three threads, with one post in each.
              Last edited by Amaury; Sat 28th Jul '12, 12:30pm.
              Former vBulletin user

              Comment


              • #8
                Originally posted by Andy View Post
                Hi Sean,

                How was you backup created? How many posts does your forum have?

                There is the possibility that your backup might be incomplete in which case you will not be able to recover from this mistake.
                tbh its still fairly new and I used a thing on my host that allows me to backup or restore stuff on both sites and I chose to back it up.=/

                Comment


                • #9
                  Originally posted by Shadow Demon View Post
                  tbh its still fairly new and I used a thing on my host that allows me to backup or restore stuff on both sites and I chose to back it up.=/
                  This is the best way to backup and restore.

                  https://www.vbulletin.com/docs/html/...nce_ssh_backup

                  https://www.vbulletin.com/docs/html/...ce_ssh_restore

                  Comment

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