<div>
Unfortunately, the table is innoDB type, data may store in ibdata1 file with no changing &nbsp;of size but no way to restore data, the tables with only .frm file doesn't exists :(<br />
<br />
Please give me a solution, even to forget all lost data.<br />

</div>


Unfortunately, the table is innoDB type, data may store in ibdata1 file with no changing  of size but no way to restore data, the tables with only .frm file doesn't exists :(

Please give me a solution, even to forget all lost data.


<div>
If you had the binary logs you might be able to restore from those - but they'd need to go back to the creation of the table:<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html</a><br />
<br />
Other than thank I think you've had it - sorry.
</div>


If you had the binary logs you might be able to restore from those - but they'd need to go back to the creation of the table:

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html [http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html]

Other than thank I think you've had it - sorry.

<div>
<div class="content wysiwyg-content">
hi Experts!<br />
<br />
I did drop database by mistake, I try to get folder if database from deleted and copy to data folder under mysql root but some table can read data (.MYD or .MYI) and some can not <br />
<br />
How can I restore database for that<br />
<br />
Thanks in advanced!<br />
<br />
HuyBD
</div>
</div>


hi Experts!

I did drop database by mistake, I try to get folder if database from deleted and copy to data folder under mysql root but some table can read data (.MYD or .MYI) and some can not 

How can I restore database for that

Thanks in advanced!

HuyBD

Drop database, restore from ibdata1 (MySQL 5.0)

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.