On 3/7/06, Mathieu Bruneau <[EMAIL PROTECTED]> wrote: > kalin mintchev a écrit : > > hi all... > > > > what's the best way to periodically back up mysql data? > > so that databases and tables can be still usable even after a mysql upgrade? > > > > thanks... > > > > > > The only absolutely portable way is the dump in text file... >
Yeah, I use MySQL Administrator, both in Windows and Linux, the only difference is the archiving of the backup files, that is done with rar in Win and tar.bz2 in Linux both with scheduled scripts, pretty easy. This method comes since version 3, did not upgrade to 5, but it saved me lots of time switching to 4, and then 4.1. > Good luck > > -- > Mathieu Bruneau > aka ROunofF > > === > GPG keys available @ http://rounoff.darktech.org > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]