We can backup and restore large my sql database using cmd. Open cmd Go to directory where my sql is installed in my cause (C:\wamp\bin\mysql\mysql5.5.16\bin)
Tag Archives: database
Remove my-sql bin | PURGE BINARY LOGS | old files
The purpose of MY SQL Binary files is to data recovery. For big database my sql binary files eat lot of disk space so If you have backed up your data and want to remove my-sql binary log files follow the procedure.
Get data from database compare by datetime or by only date using linq
1. Compare by datetime public List<tblName> getByDateTime(DateTime dateTime) { return objEntity.tblName.Where(p => p.publish_time <= dateTime).ToList(); } Call above function