Hi Ananda, I don't know how to solve this, but if you have space in another storage, try restoring your all-databases dump there and then create a new onlyone-database dump to restore in your server.
Regards. Pelle.- -----Mensaje original----- De: Ananda Kumar [mailto:[EMAIL PROTECTED] Enviado el: Sábado, 26 de Mayo de 2007 10:23 a.m. Para: MySQL General Asunto: restore one database. Hi All, I have take mysqldump of all the databases. If somebody accidently drops one database, can i restore just that database from mysqldump and apply the binary logs to restore all the data to that database. If yes, can you please let me know how that can be done. I am using version 5.0.40 regards anandkl No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.0/819 - Release Date: 26/05/2007 10:47 a.m. No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.8.0/819 - Release Date: 26/05/2007 10:47 a.m. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]