From: Michael Dykman Date: May 19 2011 1:20am Subject: Re: Restore only one database or one table List-Archive: http://lists.mysql.com/mysql/225020 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 w= rote: > 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 bac= kup > 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.