XF 1.4 SQL problems

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/
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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?
 
Upvote 0 Downvote
Brogan said:
How did you move the database?
You can't do it just by copying the files, it needs to be a dump and restore.
Click to expand...
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.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Brogan said:
If you have "file per table" enabled for InnoDB, there will be an .IBD file, but you still can't copy it manually.
Click to expand...

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 move an InnoDB database simply by copying all the relevant files listed inSection 14.2.5, “Backing Up and Recovering an InnoDB Database”.
Click to expand...

You can't copy a single table. You need ALL of the files.

If you are able to shut down your MySQL server, you can make a binary backup that consists of all files used byInnoDB to manage its tables. Use the following procedure:

  1. Shut down the MySQL server and make sure that it stops without errors.

  2. Copy all InnoDB data files (ibdata files and .ibd files) into a safe place.

  3. Copy all the .frm files for InnoDB tables to a safe place.

  4. Copy all InnoDB log files (ib_logfile files) to a safe place.

  5. Copy your my.cnf configuration file or files to a safe place.
Click to expand...

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:
Upvote 0 Downvote
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
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

MercuGmes
  • Locked
Not a bug SQL problems
Replies
2
Views
480
Paul B
P
ge66
  • Question Question
XF 2.3 gif to webp optimization problems
Replies
10
Views
175
ge66
ge66
C
  • Question Question
Oops! We ran into some problems...
Replies
12
Views
126
colenot
C
I
  • Question Question
XF 2.3 Akismet server / API problems?
Replies
0
Views
21
ISPr_Winter
I
Russ
  • Question Question
XF 2.3 "Oops! We ran into some problems" when switching style variation
2
Replies
22
Views
313
Jeremy P
Jeremy P
Back
Top Bottom