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,

This is the data that can be compressed with gzip, as follows:

#mysqldump-U root-p TM | gzip > tm_20060101.sql.gz

You can also back up to a remote machine and use-H to set up, such as

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

You can back up directly to a remote computer with an IP address of xxx.xxx.xxx.xxx.

Recovery

System crashes, rebuilding a system, or restoring a database, you can recover data like this:

#mysql-U root-p TM < Tm_20060101.sql

To recover directly from a compressed file:

#gunzip < tm_20060101.sql.gz | Mysql-u Root-p TM

Five: FAQ

Q: Why do I not have the installation files in the Setup program?

A: You may download a version that is not installed. Please give a detailed version of the information.

Q: How do I start and close MySQL?

A:linux: For example, my MySQL is installed in the/usr/local/mysql source mode

Auto: Copy/usr/local/mysql/share/mysql/mysql.server to/etc/rc.d/init.d/, and then

Chkconfig--add mysql.server can boot on the MySQL service.

Manual: Execute/usr/local/mysql/bin/mysqld_safe--user=mysql as root

Under Windows:

Automatic:

Use cmd way to the MySQL installation path under the Bin folder, execute: Mysqld-nt--install

Manual: Go directly to the MySQL installation path under the Bin folder to execute net start MySQL.

If you do not want MySQL to start the service when the computer starts, execute: mysqld-nt--remove

You can also remove the corresponding service and restart the computer in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.

Close Mysql:mysqladmin-uroot-p shutdown

Start MySQL:

Mysqld-nt--install

net start MySQL