Linked Questions

36
votes
10answers
234k views

restore table from .frm and .ibd file?

I have previously saved a copy of /var/lib/mysql/ddms directory ("ddms" is the schema name). Now I installed a new MySQL on a freshly installed Ubuntu 10.04.3 LTS by running apt-get install mysql-...
14
votes
1answer
50k views

Recover MySQL database from data folder without ibdata1 from ibd files

My WAMP directory accidentally get deleted by another user. Only data folder in MySQLis available. And, in that only database-folders (folders in "\bin\mysql\mysql5.6.12\data\" with name of databases) ...
5
votes
3answers
32k views

How to recover MySQL table structure from FRM files

What I have learned from Google searching: With MyISAM tables you can simply copy the FRM, MYD, and MYI files. In the folder for the DB I'm trying to recover, there are only FRM files and a "db.opt" ...
3
votes
2answers
13k views

Table compression in InnoDB?

I have read that table index compression happens just in MyISAM, but I came across an article in dev.mysql that said: InnoDB supports table and index compression! So now what is the pros of MyISAM? ...
2
votes
1answer
9k views

MySQL can't delete table

I have a corrupt table and I can't delete it to restore it. How do I delete this table from the database? When I try to query on the table this is what I get... mysql> SELECT * FROM tbl_company ...
1
vote
1answer
3k views

temp table (#sql-7a87_230c32.ibd along with its .frm) still exists on slave

I executed some alter statements on my master server, which have been successfully executed on master (now there is no temp table on master) and all alter also have been replicated on slave server ...
1
vote
3answers
5k views

innodb table does not exist

I have four databases each holding several hundred tables. Every table in one database suddenly returns error code 1146 Table xxx does not exist. The other databases are fine. I can see all the .ibd ...
5
votes
1answer
1k views

Dump with special characters in table column name

I'm taking over an old database, and while doing recovery tests from my dump I found out a table is wrongly backed up, the table definition is truncated. Looking at the live db I've found a column ...
0
votes
1answer
1k views

Need correct mysqlfrm command path to restore a database from .ibd and .frm files

I'm attempting to restore a database made up of only .ibd and .frm files. Why I'm doing this: An uninstall of my WAMP installation left only .ibd and .frm files, and was using MySQL 5.6.12. A ...
0
votes
1answer
587 views

Dropped connections, corrupted schema … is MySQL sick?

Lot's of problems and I wonder if it's all tracable to some root cause. I'm trying to load a simple schema related to product marketing. The symptoms are: Not being able to forward engineer said ...