List:General Discussion« Previous MessageNext Message »
From:Carlos Proal Date:July 15 2009 2:13am
Subject:Re: Copy 70GB ibdata, etc. and server won't start now
View as plain text  
Yep, you dont need to recover the database because:
1) You did a clean shutdown
2) You dont need (as i believe) an integral copy of your database, 
because its for a demo, anyway the data is 1 month older, so if you miss 
some records
that "probably" will be missing on the log those are not relevant for 
your purpose, right ?

Carlos


On 7/14/2009 9:08 PM, Daevid Vincent wrote:
>> -----Original Message-----
>> From: Carlos Proal [mailto:carlos.proal@stripped] 
>> Sent: Tuesday, July 14, 2009 5:13 PM
>>     
>>> Another thing you can do is simply erase the innodb logs. 
>>>       
>> If the dbms 
>>     
>>> really was shutdown properly then the logs are useful,
>>> they will be recreated again and you can go forward with your demo.
>>>       
>
> You're suggesting I can delete these two files?
>
> -rw-rw---- 1 mysql mysql     5242880 2009-07-14 19:18 ib_logfile0
> -rw-rw---- 1 mysql mysql     5242880 2009-07-14 18:30 ib_logfile1 
>
>
>
>   

Thread
Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
  • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
    • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • Re: Copy 70GB ibdata, etc. and server won't start nowJohnny Withers14 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
          • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
            • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
              • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
                • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent15 Jul
                  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal15 Jul
        • RE: Copy 70GB ibdata, etc. and server won't start nowDaevid Vincent14 Jul
      • RE: Copy 70GB ibdata, etc. and server won't start nowGary Smith14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowCarlos Proal14 Jul
  • Re: Copy 70GB ibdata, etc. and server won't start nowMarcus Bointon14 Jul
    • Re: Copy 70GB ibdata, etc. and server won't start nowTodd Lyons15 Jul