Try useing something like :
mysqldump -Q --opt -F --all-databases -h serverName -u root --password=yourpasswd > /some/where/backup.sql It generates a SQL commands file able to completely rebuild the DB, e.g. useful after a mysql_install_db command. Ciao, Stefano > -----Original Message----- > From: Massimo Petrini [mailto:[EMAIL PROTECTED]] > Sent: 18 July 2002 16:06 > To: [EMAIL PROTECTED]; Ilyas Keser > Subject: Re: backup > > > Also in may NT machine appear the same error. Which is the problem ? > ----- Original Message ----- > From: "Ilyas Keser" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, July 18, 2002 1:58 PM > Subject: backup > > > > Hi list... > > > > What is the best way to backup a Mysql database? I read in the > > documentation that mysqlhotcopy is the best and quickest way to do > > this. > > But I can not start mysqlhotcopy... > > Error Message is: > > > > Can't locate DBI.pm in @INC (@INC contains: > > /System/Library/Perl/darwin /System/Library/Perl > /Library/Perl/darwin > > /Library/Perl /Library/Perl /Network/Library/Perl/darwin > > /Network/Library/Perl /Network/Library/Perl .) at > ./mysqlhotcopy line > > 8. > > BEGIN failed--compilation aborted at ./mysqlhotcopy line 8. > > > > What is DBI.pm? > > > > Thanks > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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
