1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 SQL problems

Discussion in 'Installation, Upgrade, and Import Support' started by rwsender, Nov 9, 2014.

  1. rwsender

    rwsender Member

    I recently had a problem where my dedicated server got a virus, I had no option but to reinstall the OS. I went to the SQL libary, downloaded all of the files, then all of the files in my html directory. The sql files for my other programes haven't been affected. If you go the website, and inspect the element, thats what it shows.



    Code:
     
      <body>
    
      An unexpected database error occurred. Please try …
    
      <!--
    [B]
      Mysqli prepare error: Table 'supercra_forums.xf_d…[/B]
    
      -->
      </body>
    
    </html>
    
    [/]
    
    
    
    
    
    http://supercraft-mc.com/
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    The actual error is this:

    <!-- Mysqli prepare error: Table 'supercra_forums.xf_data_registry' doesn't exist -->

    That table is missing from the database for some reason.
    Contact your host and ask them to investigate who has had access to be able to delete it but you will more than likely need to restore from a backup.
     
  3. rainmotorsports

    rainmotorsports Well-Known Member

    If you copied the actual files for the database, thats not good. Unless of course the sql server process had a graceful shut down. I am no expert but a hot copy or a bad copy is going to need to go through a repair before being used. Disregard if you did a dump properly from a working server, then I have no clue.
     
  4. rwsender

    rwsender Member

    It shouldnt of been a hot copy, I couldn't properly move the mysql because my server had gotten a virus,I was unable to start any processes, I only had ftp access. I'm the only one with access, its a dedicated server that hosts my minecraft server also.

    Is there a repair for this, or will I loose all my data?
     
  5. Brogan

    Brogan XenForo Moderator Staff Member

    How did you move the database?
    You can't do it just by copying the files, it needs to be a dump and restore.
     
  6. rainmotorsports

    rainmotorsports Well-Known Member

    It's a little late for him. He is going to have to run a repair. Seems as if the server did not have a graceful shut down so the files are not immediately viable.

    I am no expert and don't wish to advise, but to point you in one direction. You can start the server with
    innodb_force_recovery set in your config and do a dump

    http://dev.mysql.com/doc/refman/5.0/en/forcing-innodb-recovery.html

    I would make sure you have a copy of the files and honestly would consult an expert or a service that specializes in database recovery.
     
  7. Brogan

    Brogan XenForo Moderator Staff Member

    In MySQL, when all tables were MyISAM, it was actually possible to copy the data files between servers; there were 3 per table: .MYI, .MYD, and .FRM.

    InnoDB is different. There are multi configurations for InnoDB, but neither allow direct copying anyway, mostly due to the transactional nature of it.

    If you have "file per table" enabled for InnoDB, there will be an .IBD file, but you still can't copy it manually.
     
  8. rainmotorsports

    rainmotorsports Well-Known Member

    I have had this argument before. Thats not what I have seen in the manual. http://dev.mysql.com/doc/refman/5.0/en/innodb-migration.html
    You can't copy a single table. You need ALL of the files.

    Thats not to say it isn't stupid. It is.

    If he no longer has the server that is dead in the water, then the only data he has is in those files. I believe some of it to be recoverable, not to say there would be enough to even bother with.
     
    Last edited: Nov 10, 2014
  9. rwsender

    rwsender Member

    It seems I have all .frm files + 1 supercra_forums.sql, if I reupload the supercra_forums.sql file will it work?

    The previous data is gone, I had to reinstall the OS, I do have the files that I downloaded on my computer but, they are all frm+ 1 sql file
     
  10. rainmotorsports

    rainmotorsports Well-Known Member

    supercra_forums.sql seems to me to imply a manual dump you did at some point. No telling how old it is until you import it. No harm in checking it out.
     
    rwsender likes this.
  11. rwsender

    rwsender Member

    I'll give that a try.
     

Share This Page