List:General Discussion« Previous MessageNext Message »
From:Ezequiel L. Pellettieri Date:May 26 2007 3:08pm
Subject:RE: restore one database.
View as plain text  
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:anandkl@stripped] 
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.
 

Thread
restore one database.Ananda Kumar26 May
  • RE: restore one database.Ezequiel L. Pellettieri26 May
    • Re: restore one database.Ananda Kumar27 May
      • Re: restore one database.John Meyer27 May
        • Re: restore one database.Ananda Kumar27 May
          • RE: restore one database.Geoffroy Cogniaux27 May
            • Re: restore one database.Ananda Kumar28 May
              • RE: restore one database.Geoffroy Cogniaux28 May
RE: restore one database.Geoffroy Cogniaux27 May