Knowledge and FAQs to learn MYSQL5

One: About MySQL5

The MYSQL5 series database is the latest version of MySQL's database, and the more popular distribution is mysql-5.0.18. MySQL English official website is http://www.mysql.com/

II: Access to MySQL5

All about the MySQL database program, can be downloaded in its English official website, but, in view of not everyone's English is very good, so we suggest that the local MySQL official website to download their own required procedures, if not found, and then to find English website.

MySQL5 has the installation version and the installation version of the points, as the name suggests, the installation version is required to be installed after the use of the installation version of the MySQL download can be used, or a simple setup can be used.

MySQL5 installation version download address:

Windows version: http://download.mysql.cn/src/2006/0218/199.html

Linux version (source package): http://download.mysql.cn/src/2006/0208/62.html

MySQL5 free installation version download address:

Windows version: http://download.mysql.cn/src/2006/0302/205.html

Three: MySQL5 installation

Installation manual for Windows edition: http://bbs.mysql.cn/thread-261-1-1.html

Linux version (source code package) installation manual: Http://bbs.mysql.cn/thread-493-1-2.html

MySQL has installed version and installation-free version, free installation version of the folder after decompression does not install the program, you can use directly.

Windows installation free version manual: http://bbs.mysql.cn/thread-552-1-1.html

IV: Backup and Recovery

Regular backup command is mysqldump, here take the TM database for example, do a brief introduction, detailed information reference

Http://info.mysql.cn/install/2006/0410/5521.html

Backup:

#mysqldump-U root-p TM > Tm_20060101.sql

Press the prompt to enter the password, which will be the TM database all the table structure and data backup to Tm_20060101.sql, because the total backup work, if the data volume assembly occupies a lot of space,