Hi Ananda,
Recovery strategy depends essentially of the backup strategy you choose. I
think that if you want be able to proceed to a restoration, database per
database, you should separate their backups. It can simply be done with this
kind of script:
for db in (`echo 'show databases;' | mysql -u <user> --password=<pwd> | grep
-v ^Database$`); do mysqldump -u <user> --password=<pwd> $db
>/mybackupdir/$db.bak ; done;
If you want to have all in one file, use tar after your backup:
cd /mybackupdir && tar -czf mybackup.tar.gz *.bak && rm -fr *.bak
Best regards,
Geof.
-----Message d'origine-----
De : Ananda Kumar [mailto:anandkl@stripped]
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
dropped, can i restore from that single database from my dump and use the
bin log and recover till "AS OF NOW".
regards
anandkl
On 5/27/07, John Meyer <john.l.meyer@stripped> 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
> >
> >>
> Well, if only one database is important enough to back up, then yes it
> will. But if you have multiple databases that you are actively using
> then you'll need to back them all up. You don't necessarily need to use
> an all databases dump, though.
>
>
> --
> The NCP Revue -- http://www.ncprevue.com/blog
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
