Basic knowledge and FAQs of MySQL 5

This article is more suitable for MySQL5 beginners. This article mainly describes the basic knowledge of MySQL5 and some common problems in actual operations. The following article describes the related content, I hope it will help you in this regard.

I. About MySQL (the best combination with PHP) 5

MySQL (the best combination with PHP) 5 series databases are the latest version of MySQL (the best combination with PHP, the popular release version is MySQL (the best combination with PHP)-5.0.18. MySQL (the best combination with PHP) English official website is http://www.MySQL (the best combination with PHP). com/

2. Obtain MySQL (the best combination with PHP) 5

All MySQL (the best combination with PHP) database programs can be downloaded from its official English website. However, since not all of them have good English skills, therefore, we recommend that you try to download the programs you need from the Chinese official website of MySQL (the best combination with PHP). If you cannot find the programs, go to the English website.

MySQL5 has the distinction between the installation version and the installation-free version. As the name suggests, the installation version can only be used after installation. The installation version of MySQL (the best combination with PHP) can be used after download, or you can use it with simple settings.

MySQL (best combination with PHP) 5 installation:

Windows: http://download.MySQL (best combination with PHP). cn/src/2006/0218/199.html

Linux source package): http://download.MySQL (best combination with PHP). cn/src/2006/0208/62.html

MySQL5 installation-free version:

Windows: http://download.MySQL (best combination with PHP). cn/src/2006/0302/205.html

Iii. Install MySQL (the best combination with PHP) 5.

Windows Installation manual: http://bbs.MySQL (best combination with PHP). cn/thread-261-1-1.html

Linux source package) Installation manual: http://bbs.MySQL (best combination with PHP). cn/thread-493-1-2.html

MySQL (the best combination with PHP) has an installation version and an installation-free version. You can use it directly if no installation program is installed in the unzipped folder.

Windows Installation-free version User Manual: http://bbs.MySQL (best combination with PHP). cn/thread-552-1-1.html

Iv. backup and recovery

The conventional BACKUP command is MySQL (the best combination with PHP) dump. Here we take the tm database as an example. For more information, see

Http://info.MySQL (best combination with PHP). cn/install/2006/0410/5521.html

Backup:

# MySQL (best combination with PHP) dump-u root-p tm> tm_20060101. SQL

Enter the password as prompted, and back up all the table structures and data of the tm database to tm_20060101. SQL. Because the backup work is always required, if the data volume occupies a large space,

The above content is an introduction to the knowledge and frequently asked questions that MySQL5 should learn.