RE: restore one database.

2007-05-28 Thread Geoffroy Cogniaux
Yes it is. This is why I suggest dumping db per db. Bye. -Message d'origine- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : lundi 28 mai 2007 10:41 À : Geoffroy Cogniaux Cc : John Meyer; MySQL General Objet : Re: restore one database. Hi Geoffroy, Very true, restore depen

Re: restore one database.

2007-05-28 Thread Ananda Kumar
p; tar -czf mybackup.tar.gz *.bak && rm -fr *.bak Best regards, Geof. -Message d'origine- De: Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé: dimanche 27 mai 2007 13:52 À: John Meyer Cc: MySQL General Objet: Re: restore one database. Hi All, I think my question was not understood.

RE: restore one database.

2007-05-27 Thread Geoffroy Cogniaux
ge d'origine- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : dimanche 27 mai 2007 13:52 À : John Meyer Cc : MySQL General Objet : Re: restore one database. Hi All, I think my question was not understood. All the database are important. Now that one of the database is accidently dropp

RE: restore one database.

2007-05-27 Thread Geoffroy Cogniaux
ge d'origine- De : Ananda Kumar [mailto:[EMAIL PROTECTED] Envoyé : dimanche 27 mai 2007 13:52 À : John Meyer Cc : MySQL General Objet : Re: restore one database. Hi All, I think my question was not understood. All the database are important. Now that one of the database is accidently dropp

Re: restore one database.

2007-05-27 Thread Ananda Kumar
AIL PROTECTED]> wrote: Ananda Kumar wrote: > Hi Pelle, > I dont have enough space on any other storage, so i was thinking if we > would > just restore one database from dump that would save lot of time , rather > than restoring all the database. > > regards > anandkl >

Re: restore one database.

2007-05-27 Thread John Meyer
Ananda Kumar wrote: > Hi Pelle, > I dont have enough space on any other storage, so i was thinking if we > would > just restore one database from dump that would save lot of time , rather > than restoring all the database. > > regards > anandkl > >> Well, if only

Re: restore one database.

2007-05-27 Thread Ananda Kumar
Hi Pelle, I dont have enough space on any other storage, so i was thinking if we would just restore one database from dump that would save lot of time , rather than restoring all the database. regards anandkl On 5/26/07, Ezequiel L. Pellettieri <[EMAIL PROTECTED]> wrote: Hi Ananda, I

RE: restore one database.

2007-05-26 Thread Ezequiel L. Pellettieri
ECTED] 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

restore one database.

2007-05-26 Thread Ananda Kumar
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 r