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 <[email protected]>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 <[email protected]> > <[email protected]> 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 <[email protected]> > <[email protected]> > 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/[email protected] > > > -- > - michael dykman > - [email protected] > > May the Source be with you. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[email protected] > > > > -- Thanks Suresh Kuna MySQL DBA
