Try to take a tab separated dump, so you can restore what ever you want in terms of tables or databases.
On Thu, May 19, 2011 at 9:53 AM, Adarsh Sharma <adarsh.sha...@orkash.com>wrote: > I take a complete backup through mysqldump command. > It includes MyISAM & Innodb tables both. > > But now i am thinking to take backup in compressed format. > > Thanks > > > Suresh Kuna wrote: > > It really depends on What kind of backup you performed a month ago rather > than the type of tables at the moment... > > On Thu, May 19, 2011 at 6:50 AM, Michael Dykman <mdyk...@gmail.com> > <mdyk...@gmail.com> wrote: > > > > What tables types are you using? If MyISAM, this can be done easily. > If InnoDB it will depend on your settings (file-per-table) > > - michael dykman > > On Tue, May 17, 2011 at 7:11 AM, Adarsh Sharma <adarsh.sha...@orkash.com> > <adarsh.sha...@orkash.com> > wrote: > > > Dear all, > > I read all the different ways to backp and restore data in mysql. > Say, i perform a complete backup of all databases 1 month ago > > Now, is it possible to restore only a single database from a complete > > > backup > > > file of 250 GB that contains backup of more than 50 databases. > > Or if we want to restore only selected tables in a database. > > How to do this ? > > Is it possible or not. > > > Thanks > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > > -- > - michael dykman > - mdyk...@gmail.com > > May the Source be with you. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com > > > > -- Thanks Suresh Kuna MySQL DBA