How screwed am I?

So what happens when you stop mysqld and copy files to the new location, and restart mysqld? IIRC for Windows, that's all you should have to do.

EDIT: Are you saying that your InnoDB tables are missing after restarting mysqld? Seems like you might have just missed some files while copying

You might be better off getting some advice from Windows MySQL users.
 
When I copy everything over, and start SQL, it just crashes.

Yes, I do have the IBData file:
 

Attachments

  • Capture.webp
    Capture.webp
    33.9 KB · Views: 34
SneakyDave said:
So what happens when you stop mysqld and copy files to the new location, and restart mysqld? IIRC for Windows, that's all you should have to do.

EDIT: Are you saying that your InnoDB tables are missing after restarting mysqld? Seems like you might have just missed some files while copying

You might be better off getting some advice from Windows MySQL users.
Click to expand...


The issue is Dave, is he took the backup while mysql was still running.

Pope Viper said:
When I copy everything over, and start SQL, it just crashes.

Yes, I do have the IBData file:
Click to expand...


Can you get those to me and ill take a look?
 
Maybe something from these pages would help?
http://dev.mysql.com/doc/refman/5.5/en/crashing.html

http://forums.mysql.com/read.php?156,398589,398589

Edit: This link may be something worth trying? It's expensive
http://www.datarecovery-info.com/database-recovery/mysql-recovery.html

Key Features
  1. MySQL repair support for database storage engines – MyISAM and InnoDB
  2. Support to different MySQL versions – Including 3.x, 4.x, 5.x, and 6.x versions
  3. Easy MySQL database recovery with user-friendly interface
  4. Includes option to select only desired components
  5. Recovers and restores MyISAM (.myd, .myi and .frm) and InnoDB (.ibdata, .ibd and .frm files
  6. Secure connection with MySQL is setup while MySQL database repair
  7. Preview of recoverable components – MySQL installation not necessarily required
  8. Comprehensive MySQL recovery solution to restore all data types (except spatial)
  9. Support to recover databases created on Windows and Linux platforms
  10. Manual MySQL database recovery for files stored at default location to install MySQL
  11. Ability to restore tables on which auto-increment and default properties have been applied
 
Mike - Could you give Slavik access to that file I sent you? I would do it, but my connection is slow as hell.

Meantime, I'm looking into something. I took a physical to VM image of my server from a month or so ago, I'm going to see if that's viable, if so, I'll take SQL dumps, and just go on.

Ideally, I would like to recover the data from the files I gave to Mike, but at least I've got SOMETHING to work off of.
 
I'm not very knowledgeable in the subject at hand (or I would attempt to help), but I must say, it is really refreshing to see individuals go out of their way to help a person in this manner. I applaud all of involved for your efforts.
 
SneakyDave said:
Edit: This link may be something worth trying? It's expensive
http://www.datarecovery-info.com/database-recovery/mysql-recovery.html

Key Features
  1. MySQL repair support for database storage engines – MyISAM and InnoDB
  2. Support to different MySQL versions – Including 3.x, 4.x, 5.x, and 6.x versions
  3. Easy MySQL database recovery with user-friendly interface
  4. Includes option to select only desired components
  5. Recovers and restores MyISAM (.myd, .myi and .frm) and InnoDB (.ibdata, .ibd and .frm files
  6. Secure connection with MySQL is setup while MySQL database repair
  7. Preview of recoverable components – MySQL installation not necessarily required
  8. Comprehensive MySQL recovery solution to restore all data types (except spatial)
  9. Support to recover databases created on Windows and Linux platforms
  10. Manual MySQL database recovery for files stored at default location to install MySQL
  11. Ability to restore tables on which auto-increment and default properties have been applied
Click to expand...

Just thought id throw my 2 cents worth in on the above quote... I have used this company and their services are impeccable.. Once upon a time when i first got started in forums i was using a free IPB hosted solution, of course i had zero access to any of my files, FTP or server.. Yet somehow they managed to gather all my data and move my site off of IPBFree and on to my own server without so much as a hicup.. This was years ago but i recall the only thing we couldn't save were passwords. However the keyword in the quoted text is "Expensive"
 
I'm making some progress, I was able to get onto my VM, and dump my forums, I'll have to do some updating of permissions.

The only problem I'm having now, is getting a dump of my Ampache DB, it's about 2 G, and when I do any import via SQLYog, it just pukes, I'm trying a couple of other things now.
 
Pope Viper said:
I'm making some progress, I was able to get onto my VM, and dump my forums, I'll have to do some updating of permissions.

The only problem I'm having now, is getting a dump of my Ampache DB, it's about 2 G, and when I do any import via SQLYog, it just pukes, I'm trying a couple of other things now.
Click to expand...


Great to hear your making progress!
 
Pope Viper said:
I'm making some progress, I was able to get onto my VM, and dump my forums, I'll have to do some updating of permissions.

The only problem I'm having now, is getting a dump of my Ampache DB, it's about 2 G, and when I do any import via SQLYog, it just pukes, I'm trying a couple of other things now.
Click to expand...
Sqlyog tends to have problems if something isn't quoted right. If you a loose ' or " and the strings get confused.

Also if you can break the dump apart into manageable sections. Ultra edit is great for splitting huge files like that apart on windows.
 
@Pope Viper

What are the names of the most important databases, I think I have them sorted, but the dump now will take a while... so want to get the important ones to you to check first.
 

Similar threads

W
  • Question Question
XF 2.3 I screwed up the upgrade (Did not merge files)
Replies
7
Views
71
wmarcy
W
TorontoJoe
  • Question Question
XF 2.3 DM's - Am I missing something?
Replies
8
Views
144
TorontoJoe
TorontoJoe
Fullmental
XF 2.2 What am I doing wrong with addon IDs?
Replies
4
Views
66
Deleted member 184953
D
R
  • Question Question
How should I update the addon?
Replies
1
Views
34
Paul B
P
hIBEES
  • Solved
XF 2.2 What am i doing wrong....
Replies
10
Views
366
hIBEES
hIBEES
Back
Top Bottom