- to look at all HACK activity on port 3306 — 2019-05-21
grep ‘DPT=3306’ /var/log/messages | grep -v 71.209.212.220 | sed -e ‘s/^.* SRC=//’ | sed -e ‘s/ DST=.*$//’ | sort -u | sed -e ‘s/^/csf —tempdeny 999999 /’ | sed -e ‘s/$/ ;/’ ;
2010-04-12 – database stopped because log file was too full!
repair table tableName ;
command to fix errors like: Incorrect key file for table
mysqldump —no-data – dump just tables and keys without data
RENAME TABLE OldTablName TO NewTableName ;
command to rename a table!
location of datafiles: /var/lib/mysql
location of logs: /var/log/mysqld.log
to start up mysql and log in as root:
mysql -u root -p
location of root password: /etc/my.cnf
to restart the database:
/etc/init.d/mysqld start|stop|restart
to look at database errors:
/var/lib/mysql/edwardsmark.com.err
to look at database activity:
/var/log/mysqld.log
to see the general system settings starting with “general”: (2010-05-19)
show variables like ‘general%’;
