Michael I have a nice perl program I wrote that I use to dump from MySql to a tab delimited ASCII file. I would pass it along if you think it would help...
~Kelly W. Black -----Original Message----- From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net] Sent: Monday, November 11, 2002 2:38 PM To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: mysqlhotcopy point-in-time recovery Heikki Tuuri wrote: >you cannot use mysqlhotcopy to back up InnoDB type tables. Only the .frm >files are in the database directory, while the data is in ibdata files. >mysqlhotcopy does not copy ibdata files or ib_logfiles, and if it would do >that, the copies could be corrupt because of writes the database meanwhile >does to these files. > > Shouldn't it be renamed to myisamhotcopy then? ... if it doesn't work with MySQL as a whole, the tool should be renamed. Plus, a tool that does in fact work with MySQL as a whole would be nice. SQL, QUERY -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock --------------------------------------------------------------------- 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