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