Mysqlhotcopy can copy the files anywhere. Just have it copy under ur MySQL data directory and the new copy will be visible instantly. e.g. /var/lib/mysql/data/offline_copy U will instantly see a new database named "offline_copy" with the copy of ur table in it.
Brian Dunning wrote: > > Thanks Chris, this sounds great but when I read about mysqlhotcopy I > didn't see a way to make it create a live table that's open within > the same database, it seems to want only to create a separate backup > file in some directory. > -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
