Articles

 How can I monitor what my MySQL server is doing?

A handy little Linux application called mytop fits this just perfectly. This is a near-time...

 How do I backup MySQL in Linux?

1. Copying from the mysql directoryBy default, MySQL databases on servers that use Linux are...

 How to create a MySQL database backup

The following will create a gz compressed SQL dump from your chosen database # mysqldump...

 How to install Mysql

Installing MySQL on a CentOS system can be done from the CentOS repositories with yum:CentOS...

 MySQL Optimization / Repair Information

How MySQL Uses MemoryThis page lists some of the ways that the mysqld server uses memory, and...

 Mysql Basic Commands

[mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create...

 Repairing MySQL tables that will not open

This should be handled on a case by case basis, but if you are using the default MySQL table type...

 Securing MySQL

Due to differing needs and requirements this is difficult to answer except on a case by case...