how to add a cron job through ssh command crontab -e

how to add a cron job through ssh command crontab -e

Asif Munir October 10, 2015

The fields in cron are: m h dom mon dow command…

How to extract mysql data files from cpmove backups

How to extract mysql data files from cpmove backups

Asif Munir October 10, 2015

for a in *;do filenamewithonedot="${a%.*}";filename="${filenamew…

How to List all tables using InnoDB or MyISAM on Mysql Command

How to List all tables using InnoDB or MyISAM on Mysql Command

Asif Munir October 08, 2015

This query lists all InnoDB tables and their databases in MySQL: SELECT table_name,…

How to Backup All Mysql Databases in Cpanel server in separate mysql files

How to Backup All Mysql Databases in Cpanel server in separate mysql files

Asif Munir October 08, 2015

How to Backup All Mysql Databases in Cpanel server in separate mysql files mysqld…

How to empty or delete /var/lib/mysql/ .err files?

How to empty or delete /var/lib/mysql/ .err files?

Asif Munir October 08, 2015

You can clear the /var/lib/mysql/.err files, but if you have a lot of errors outputti…

How to Check or Repair all tables from all databases in MySQL with mysqlcheck

How to Check or Repair all tables from all databases in MySQL with mysqlcheck

Asif Munir October 06, 2015

he command is this: mysqlcheck - u root - p --auto-repair --check --all-databases …

How to restoregrants to restore the user's database access

How to restoregrants to restore the user's database access

Asif Munir October 05, 2015

restoregrants to restore the user's database access Execute one of the followi…