Dnia Wed, 28 May 2003 12:57:59 +0200 Jarek Jarzebowski <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hi, > > I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM > and InnoDB tables. MySQL docs shows what is the best way to backup > InnoDB tables but I don't want to shutdown db server every backup time. > > I suppose it is not a good idea to just copy database files and innodb > log files to the safe place because of unwanted rollbacks danger. > > What if I use mysqldump to backup databases data, and then I copy innodb > log files to the safe place? I suppose I should flush tables first. > You can mysqldump InnoDB tables too. Copying InnoDB files (data or redologs) without shuting down mysql is a bad idea. You can also use mysql replication if you have spare server and do a cold backup from it. -- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215770 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
