This is second tutorial from a series of tutorials about MySQL. We will begin with some MySQL general tips.
1. MySQL General Tips
1.1 MySQL Logging
When you develop complex application it is useful to log every query to a file, that way you will know for example if your command from a PHP script will add values to your database. To enable logging it depends on your operating system. For FreeBSD you must edit /usr/local/etc/rc.d/mysql-server script and on the command_args line the following string: –log=/var/log/mysql.log. Then restart mysql-server.
For Linux distribution we will add later the info on how to activate logging of MySQL querries.
1.2 Repair a MySQL Database
If you have errors in your tables from your databases you can check and repair using mysqlcheck utility from your shell (this comes with MySQL package):
This is a quick tutorial on how to use MySQL Database. Examples from this tutorial were tested using MySQL 5.5.x.
1. MySQL Installation
We will not cover MySQL installation on a specific platform which would be trivial and depend on your OS. Just visit www.mysql.com go to Download section and from there the version you need for your OS
If you are using Windows you might instead look for an already build WAMP package which is easy to install and configure, and you’ve got your whole package for Web development. You can get WAMP from www.wampserver.com.
If you are using Linux, FreeBSD or other UNIX-like OS you might install MySQL by using a package manager from respective distribution.