List:General Discussion« Previous MessageNext Message »
From:Adarsh Sharma Date:May 19 2011 11:01am
Subject:Re: Restore only one database or one table
View as plain text  
Johan De Meersman wrote:
> ----- Original Message -----
>   
>> From: "Suresh Kuna" <sureshkumarilu@stripped>
>>
>> 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

Thread
Restore only one database or one tableAdarsh Sharma19 May
  • Re: Restore only one database or one tableMichael Dykman19 May
    • Re: Restore only one database or one tableSuresh Kuna19 May
      • Re: Restore only one database or one tableAdarsh Sharma19 May
        • Re: Restore only one database or one tableSuresh Kuna19 May
          • Re: Restore only one database or one tableJohan De Meersman19 May
            • Re: Restore only one database or one tableAdarsh Sharma19 May
              • Re: Restore only one database or one tableEric Bergen19 May
                • Re: Restore only one database or one tablePrabhat Kumar19 May
            • Re: Restore only one database or one tablehsv20 May