I'm screwed.
Did you use file_per_table?
If not, do you have the ibdata file?
I'm screwed.
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:
Edit: This link may be something worth trying? It's expensive
http://www.datarecovery-info.com/database-recovery/mysql-recovery.html
Key Features
- MySQL repair support for database storage engines – MyISAM and InnoDB
- Support to different MySQL versions – Including 3.x, 4.x, 5.x, and 6.x versions
- Easy MySQL database recovery with user-friendly interface
- Includes option to select only desired components
- Recovers and restores MyISAM (.myd, .myi and .frm) and InnoDB (.ibdata, .ibd and .frm files
- Secure connection with MySQL is setup while MySQL database repair
- Preview of recoverable components – MySQL installation not necessarily required
- Comprehensive MySQL recovery solution to restore all data types (except spatial)
- Support to recover databases created on Windows and Linux platforms
- Manual MySQL database recovery for files stored at default location to install MySQL
- 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?
With what error? MySQL's error log should hopefully give you *some* sort of info.When I copy everything over, and start SQL, it just crashes.
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.
Sqlyog tends to have problems if something isn't quoted right. If you a loose ' or " and the strings get confused.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.
We use essential cookies to make this site work, and optional cookies to enhance your experience.