From: Eric Bergen Date: May 19 2011 2:42pm Subject: Re: Restore only one database or one table List-Archive: http://lists.mysql.com/mysql/225044 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable The mysql command line has the -o option to only execute queries for the default database. This can be used to restore one database from a dump file that contains many. For specific tables you can setup a restore user that only has permissions on the tables you want to restore then use the -f flag to continue on error. Only use this in emergencies though. On Thursday, May 19, 2011, Adarsh Sharma wrote: > Johan De Meersman wrote: > > ----- Original Message ----- > > > From: "Suresh Kuna" > > Try to take a tab separated dump, so you can restore what ever you > want in terms of tables or databases. > > > > Uhh. I'm a bit fuzzy today, but I really don't see how a tab-separated du= mp will help split off tables or databases :-) > > > To answer the original question, though; the technically accurate answer = is "yes, you can". It's made "easy" because mysqldump conveniently dumps da= tabase-per database and table-per table. It's a bugger to do, however, beca= use if you take a monolithic dump you need to open the whole dumpfile in a = text editor and copy the data you want to another file or straight to the M= ySQL commandline. Good luck with your 250G backup :-) > > You can use sed or awk to look for markers and split the file up that way= . You'd be much better off in the future to dump database-per-database, and= if you think you need it table-per-table. 's Not all that hard, just scrip= t to loop over the output of show databases and show tables. Probably plent= y of scripts on the internet that do exactly that. > > Compressing your dumps is a good idea, too - the output is a text file, s= o bzip2 will probably compress that a factor 10 or better. Simply use bzcat= to pipe the file back into the MySQL client to restore. > > > > > That's pretty nice & What I am expected to hear. > > I will let u know after some practical implementation. > > Thanks & best Regards, > Adarsh Sharma > --=20 Eric Bergen eric.bergen@stripped http://www.ebergen.net