which is the command to restore from a dump?? -----Messaggio originale----- Da: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]] Inviato: venerd́ 22 novembre 2002 14.23 A: Massimo Bandinelli Cc: [EMAIL PROTECTED] Oggetto: Re: Recovery
Dobrư den, sexta-feira, 22 de novembro de 2002, 10:59:38, napsal jste: MB> I'd want to backup my database. Which is the best method between mysqldump and copying the /usr/local/var directory? MB> Thanks, Massimo. you use InnoDB ? the best and fast metod to backup your InnoDB databases is using the non-free Hotbackup tool ( see http://www.innodb.com/hotbackup.html ) and after this copy the .frm files from mysql data dir , else you must use mysqldump. you use MyISAM ? use mysqldump or copy the /usr/local/var. if you running on windows , you must to execute a "flush tables" before start copy of .MYD , .MYI and .frm files. bye, ------------------------------------------------------------------------- ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento ------------------------------------------------------------------------- E S C R I B A I N F O R M A T I C A ------------------------------------------------------------------------- The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into "my eyes" look: cannot open my eyes ------------------------------------------------------------------------- Reply: [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
