Hi Subhakar, I would be interested to know what you mean with roll forward ?
In case you have another backup let's say @10AM you could use this one, but if you dont have another backup where do you want to do a roll forward from ?? Do I miss something here ?? Best regards Nils Valentin Tokyo/Japan 2003年 6月 27日 金曜日 09:03、Subhakar Burri さんは書きました: > Can I roll forward if I do backups using Mysqldump? Say, I did backups > using Mysqldump @ 8:00 AM and my instance crashed @ 2:00 PM. I can restore > the tables (both Innodb and MyISAM tables) from my 8:00AM backup, but can I > roll forward the data that changed after 8:00 AM or do I lose the data > after 8:00 AM. Pls clarify... a link to relevant information would be just > fine too... > > Thankx in advance > SB > > -----Original Message----- > From: Keith C. Ivey [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 2:49 PM > To: [EMAIL PROTECTED] > Subject: Re: Best Pratices for mySQL Backups in Enterprise > > On 26 Jun 2003 at 17:16, Ware Adams wrote: > > mysqldump creates text files containing insert statements that > > recreate a table and repopulate it with data. They are somewhat > > portable across database servers and human editable if necessary. > > They take up less space than the original table because they do not > > contain indices (only the statements that would create the indices). > > The dump file will be larger than the MyISAM data file for the > original table -- especially if you have many non-text columns > (dates, numbers, ENUM columns, etc.). In some cases, when you have > large indexes, the index file will be large enough that it and the > data file combined will be larger than the dump file, but in some > cases it won't be. I wouldn't consider the difference in size, > whichever way it goes, to be significant in deciding between backup > methods. > > -- > Keith C. Ivey <[EMAIL PROTECTED]> > Tobacco Documents Online > http://tobaccodocuments.org > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
