Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mysql logs files - how to flush

Status
Not open for further replies.
Nov 18, 2005
43
US
Hello. I see some log files that are taking up 20 megs. How do I get rid of these, view them or work with them.

Using mysql 4.0.24

I have attempted the following:


E:\mysql2\bin>mysqladmin.exe -u root -p -v flush-logs
Enter password: *******

E:\mysql2\bin>mysqladmin.exe flush-logs -u root -p
Enter password: *******

However I still see the following files:
01/05/2006 11:49 PM 10,485,760 ibdata1
05/11/2005 03:44 PM 25,088 ib_arch_log_0000000000
01/05/2006 11:50 PM 5,242,880 ib_logfile0
05/11/2005 03:44 PM 5,242,880 ib_logfile1

I am a bit confused. Thanks.
 
ibdata1 is the Interbase data file. If you delete that, you lose your database. I would suspect that ib_logfile0 is the current Interbase log file, which is probably needed for proper operation of the database. The older-dated log files can probably be safely deleted.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top