Transaction log file is full

[sonajain]

Hi,

The database transaction log file is full. I cannot delete the log file. when I try to take backup it throws error. Any other way so that I can write more transaction without any problem. Please reply matter is urgent.

[ronverdonk]

Have you tried

mysqladmin flush-logs 
or the SQL statement FLUSH LOGS.

or the MySql documentation, especially the part on Log file maintenance

Ronald :cool: