MySQL : Guide book
MySQL is an open source database, famous and well know.
Moreover, MySQL is an open-source relational database. In a nutshell, for those unfamiliar with it: A database is where an application keeps its stuff.
Tutorial
Installation of MySQL for debian 5:
http://articles.slicehost.com/2011/3/10/installing-mysql-server-on-debian
Tricks
Repair database
Issue
frenzy:~# /etc/init.d/mysql start Starting MySQL database server: mysqld. Checking for corrupt, not cleanly closed and upgrade needing tables..
Investigation
I found this link : http://www.2by2host.com/articles/corrupt-not-cleanly-closed-upgrade-needing-table
*Where are my data located ?*
- cat /etc/mysql/my.cnf
- /var/lib/mysql
Show process
Show all the process for the current user when not logged as root.
show processlist;