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]

Reply via email to