great. the files are exactly as you describe. we are doing transactions when we load. auto commit is off, and the loader commits rows after a certain number has hit the database. however, if I understand you correctly, once a load is complete and everything has been committed, we are free to delete these files if we want. database backup and recovery is a separate issue?
thanks for your response jeff Jeff Kilpatrick wrote: > > Jeff- > > Actually, thsee sound like the binary log files used primarily for > replication. If you're on host doctorpants, they'll be > doctorpants-bin.001 > doctorpants-bin.002 > doctorpants-bin.index > and so forth. If you don't want a write query log and aren't doing > transactions, remove the binlog option from my.cnf and do a > mysql> RESET MASTER; > to remove the files. They contain none of your data, just what it took > to get there. You can use mysqlbinlog to translate them to SQL files. > > -jeff > > On Fri, 2003-03-21 at 12:52, Jeff Mathis wrote: > > we're using mysql-max4.04 on solaris 2.8. all tables are InnoDB tables. > > > > I see in the data directory a series of <host>-bin files. I'm assuming > > these are the index files. Is this correct? the sum total size of these > > files are larger than the files I've allocated for data. How can I > > manage these files? What happens if I delete them> How can I tell if any > > of them are stale? > > > > 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 -- Jeff Mathis, Ph.D. 505-955-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6 http://www.predict.com Santa Fe, NM 87505 --------------------------------------------------------------------- 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
