Announcement

Collapse
No announcement yet.

Switched hosts....but many problems

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

  • Switched hosts....but many problems

    I recently changed hosts, although I haven't 'officially' done so because I haven't transferred my database successfully over to the new host yet.

    My current forum is at

    www.ffimpulse.com/forum

    and the new forum is at http://ffimpulse.empyron.com/forum

    I cannot login to the admin cp, it just says I logged in successfully but puts me back to the login screen....so I can't really do anything.

    My database sql size was about 68 mbs.

    My host (hostrocket) imported the database for me.

    Here is what they said the first time I asked them

    Hi Brian,

    I attempted to import your ffi file into a new
    database named ffi however my initial attempt
    failed as the following SQL syntax error was
    received:

    ERROR 1064 at line 64619: 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 \'desc text NOT NULL, ability text NOT NULL,
    hp int(15) NOT N

    I dropped that database and made a second attempt
    using the -f (force) switch which forces MySQL to
    bypass errors and upload what it can. This resulted
    in approximately 100MB of data being imported to
    the database, however due to the error(s) you may
    or may not be able to use the database as is as
    some tables may not be complete.

    You may want to add a database user, configure your
    VBulletin script, see if it will load and if so what
    if any data is missing. If the restored database is
    too damaged/incomplete to be usable I\'d suggest that
    you might want to contact VBulletin or post to their
    support forum for additional suggestions.

    If you need anything else please let me know. Thank
    you for using HostRocket!
    After that I decided to prune down my forums and get rid of unneccasarry stuff on the forums.....I got the database size down from 130 or so mbs down to 68. So I reuploaded to sql file to the ftp so that they could ssh it, and heres what they responded.

    Hi,

    I removed the database and attempted to reimport your SQL
    backup file. I received the same error messages Don
    reported. I removed the database and tried again with the
    -f (force) option. This time it successfully created a
    populated database, but many additional errors were
    reported, including (but not limited to):
    ERROR 1146 at line 57601: Table \'empyron_ffi.inferno_heal\'
    doesn\'t exist
    ERROR 1146 at line 57672: Table \'empyron_ffi.inferno_items\'
    doesn\'t exist
    ERROR 1146 at line 59620: Table
    \'empyron_ffi.inferno_triad_card\' doesn\'t exist
    ERROR 1146 at line 63859: Table \'empyron_ffi.inferno_user\'
    doesn\'t exist

    Each of those errors was actually repeated many times, with
    only the line number different in each case.
    What do you guys suggest I do. What can I do?
    ::::::: http://ffimpulse.com
    ::::::: http://ffimpulse.com/forum

  • #2
    How are you making the backup? It sounds like it is not complete.
    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
      The first backup was made through cpanel's database backup.

      The second time I did it through the admincp on vbulletin.

      Is there a different way i'm supposed to do it?
      ::::::: http://ffimpulse.com
      ::::::: http://ffimpulse.com/forum

      Comment


      • #4
        The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. Please see the instructions here:

        Backup:
        http://www.vbulletin.com/docs/html/m...nce_ssh_backup

        Restore:
        http://www.vbulletin.com/docs/html/m...ce_ssh_restore
        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
          Ok those steps were followed, and upon retrying...........

          Hi,

          Attempting to import your database backup at
          public_html/ffimpulse/ffimpulse.com.sql without the \"force\"
          option, I still get the following error:

          ERROR 1064 at line 57951: 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 \'desc text
          NOT NULL, ability text NOT NULL, hp int(15) NOT N

          With the \"force\" option, I still get that error plus the
          same errors I included in my last reply.

          From looking through the SQL file and examining that error
          message, I think that MySQL may be having an issue with the
          \"inferno_heal\" table containing a row named \"desc\". It
          seems that \"desc\" may be a reserved word within MySQL and as
          such it is resulting in a syntax error when attempting to
          import a table containing a row with that name.

          I checked out the internals of the SQL file and the code
          that defines the \"inferno_items\" and \"inferno_user\" tables.
          \"inferno_items\" also has a row named \"desc\"; additionally,
          it has rows named \"type\" and \"level\", which may be reserved
          words as well. \"inferno_user\" contains a row named \"level\".

          If I am correct about those being reserved words, there is
          no way that the database can be imported without
          modification to the underlying structure first. Be aware
          that renaming rows in the database will also necessitate
          modifying any program code that accesses those rows.
          ::::::: http://ffimpulse.com
          ::::::: http://ffimpulse.com/forum

          Comment


          • #6
            What 'force' option? Which restore method are you using?
            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


            • #7
              sounds like they are using mysql admin.

              Comment

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