The psacct or acct package provides several features for monitoring process activities.
ac command prints the statistics of user logins/logouts (connect time) in hours.
lastcomm command prints the information of previously executed commands of user.
accton commands is ... [more]
mysqldump command in mysql helps to create textfile dumps of databases. here is few commands to do in commandline
Single Database backup:
Multiple Database backup:
All Database backup:
Restoring from Database backup:
To restore a single database from dump of ... [more]
DROP PROCEDURE IF EXISTS `sp_getDateFormat` $$
CREATE PROCEDURE `sp_getDateFormat`(StartDate varchar(15), EndDate varchar(15), Cond varchar(5))
READS SQL DATA
DECLARE totalDay INT DEFAULT 0;
DECLARE i ... [more]