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 <adarsh.sha...@orkash.com> wrote: > Johan De Meersman wrote: > > ----- Original Message ----- > > > From: "Suresh Kuna" <sureshkumar...@gmail.com> > > 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 dump > 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 > database-per database and table-per table. It's a bugger to do, however, > because 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 > MySQL 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 script to > loop over the output of show databases and show tables. Probably plenty of > scripts on the internet that do exactly that. > > Compressing your dumps is a good idea, too - the output is a text file, so > 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 > -- Eric Bergen eric.ber...@gmail.com http://www.ebergen.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
