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:[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 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 <[EMAIL 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 > > > >> > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
