might be my blog will help you :) http://adminlinux.blogspot.com/2009/11/extract-single-dbtable-from-dump-file.html
have a good time.. On Thu, May 19, 2011 at 7:42 AM, Eric Bergen <eric.ber...@gmail.com> wrote: > 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=aim.prab...@gmail.com > > -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
