Re: Restore only one database or one table

2011-05-19 Thread Johan De Meersman
- 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

Re: Restore only one database or one table

2011-05-19 Thread Adarsh Sharma
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

Re: Restore only one database or one table

2011-05-19 Thread Eric Bergen
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

Re: Restore only one database or one table

2011-05-19 Thread Prabhat Kumar
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

Re: Restore only one database or one table

2011-05-19 Thread Hal�sz S�ndor
2011/05/19 12:43 +0200, Johan De Meersman 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

Restore only one database or one table

2011-05-18 Thread Adarsh Sharma
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

Re: Restore only one database or one table

2011-05-18 Thread Michael Dykman
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 adarsh.sha...@orkash.com wrote: Dear all, I read all the different ways to backp and restore data

Re: Restore only one database or one table

2011-05-18 Thread Suresh Kuna
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 mdyk...@gmail.com wrote: What tables types are you using? If MyISAM, this can be done easily. If InnoDB it will depend on your

Re: Restore only one database or one table

2011-05-18 Thread Adarsh Sharma
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...

Re: Restore only one database or one table

2011-05-18 Thread Suresh Kuna
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 adarsh.sha...@orkash.comwrote: I take a complete backup through mysqldump command. It includes MyISAM Innodb tables both. But now i am