Bluehost.com Web Hosting $6.95

Recovering InnoDB after low disk space problems

This is a discussion on Recovering InnoDB after low disk space problems within the MySQL Database forums, part of the Database Forums category; Hi, I use MySQL 5 with a mix of InnoDB and MyISAM tables, and I recently ran low on disk ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 11-04-2006
lesley.court@gmail.com
 
Posts: n/a
Default Recovering InnoDB after low disk space problems

Hi,

I use MySQL 5 with a mix of InnoDB and MyISAM tables, and I recently
ran low on disk space due to rapidly expanding log files.

This ultimately caused the mysqld process to stop working (Windows XP),
and it could not be restarted. After copying all of the data files and
re-installing MySQL, I copied the ibdata and two log files across to
the new install, which recovered most of the data. Unfortunately
several (perhaps 40%) of the InnoDB tables were not recovered.

I would hope that there is some way of retreiving these missing tables,
and that they are (for whatever reason) just hidden or not-accessed
within the data files.

Any pointers or suggestions on recovering more of the data would be
gratefully received.

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 11:05 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0