Creating MySQL Dump

cd /var/lib/mysql

ls -l | grep

mysqldump |db| > |db|.sql

mysqladmin create |newdb|

mysql |newdb| < |db|.sql

*-------------------------------------------------------------------------------------------------------------------------------------------------*

Get MySQL version

mysql -i;

or

login to mysql and run the following command this returns the servers

version.

mysql> select version();

+-----------+

| version() |

+-----------+

| 3.23.58 |

+-----------+

1 row in set (0.02 sec)

*-------------------------------------------------------------------------------------------------------------------------------------------------*

MySQL Error Log

/var/lib/mysql/server.hostname.err

*-------------------------------------------------------------------------------------------------------------------------------------------------*