How to check http and mysql uptime

httpd fullstatus | grep uptime

mysqladmin version | grep UptimeWHM>> Main >> Server Configuration >> Tweak Settings >> MySQL® :Update

How to check if innoDb engine enabled in Mysql
Steps: Overview:
1. Start MySql
(you will need version 3.23.29 or higher)
2. -Run the SQL query
SHOW VARIABLES LIKE ‘have_innodb’;
3. -This should show
+—————+——-+
| Variable_name | Value |
+—————+——-+
| have_innodb | YES |
+—————+——-+
********************************************************************************
mysql_pconnect
root@berkshire]# cd /home/greasebu/public_html/system/phpgwapi/inc/adodb/drivers
root@berkshire]# vi adodb-mysql.inc.php ————> check ( /mysql_pconnect to mysql_connect )

********************************************************************************
Restoring mysql databases
As root
======
mysql database < databasebackup.sql
As user
======
mysql -u username -p database < dump_file.sql
*******************************************************************************************************************************************************************
Increasing mysql packet size in my.cnf
For increasing mysql packet size add the following entry in my.cnf and restart mysql server.
[mysqld]
max_allowed_packet=16M
********************************************************************************
mysql querry to delete a user
mysql> delete from user where user=’username’;
mysql> FLUSH PRIVILEGES;
********************************************************************************
file where mysql root password is stored
If you forgot your mysql root password you can get it from
/root/.my.cnf
********************************************************************************