MySQL InnoDB error in dictionary

[Petter Adsen]

On Wed, 8 Jul 2015 05:36:01 -0700
Tony Baechler <bats at batsupport.com> wrote:

> Now, I'm having trouble and I hope I didn't do permanent damage.  I
> did read the link below and I think section 14.20.3 deals with my
> problem, but I'm afraid to do anything because I don't want to lose
> any data.  What should I do? Is it safe to delete the .frm files?  I
> am a novice with MySQL.  I don't mind using the shell and entering
> commands, but I don't know what to do.  The manual made no sense to
> me and left me confused.  It looks like I should delete the .frm
> files, but I'm afraid the data will then be permanently lost. Then
> again, maybe it's lost anyway.  Please help.  Here is the output from
> the error log:

Before I say anything, please note that I haven't dealt with SQL
servers in over 10 years, so I can't really tell you much. That said,
if you believe that deleting the files might help, but are afraid to
try, why not just move them out of the way? Use "mv" instead of "rm",
and put the files in your home directory, for example, then see if that
helps.

mv file /home/user

Will move the file named "file" in the current directory to the
directory /home/user (exchange "user" with your username and "file"
with the name of the file you want to move).

Whether or not you have deleted anything essential I can't tell you, I
just thought I might as well suggest this since nobody else had replied.

Then again, if you have deleted /var/lib/mysql/ib* as you said, the
goose might be cooked. If you wanted to delete log files, I would guess
those belonged in /var/log/mysql. Do you have backups? If this is an
ext3 or ext4 filesystem, there is a tool called "extundelete" that
*might* help you, you could try that.

Petter

-- 
"I'm ionized"
"Are you sure?"
"I'm positive."
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 213 bytes
Desc: OpenPGP digital signature
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20150709/e93a2105/attachment.sig>