Shulou(Shulou.com)05/31 Report--

This article mainly talks about "skills for using SQL database". Friends who are interested may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn the skills of using SQL database.

Which method should be used to create users?

There are several ways to create a user: GRANT statements, CREATEUSER statements, and direct manipulation of the user table. In general, it is best to use GRANT or CREATEUSER statements rather than inserting user information directly into the user table, because global-level permissions and other account information are stored in the user table, which may have a great impact on the MySQL server if the records in the user table are accidentally broken.

Mysqldump backup files can only be used in MySQL?

The text file backed up by mysqldump is actually a copy of the database, which can be used not only to restore the database in MySQL, but also to restore the database in other databases such as SQLServer or Sybase through simple modifications to the file. This realizes the migration between databases to some extent.

How do I choose a backup tool?

Copying data files directly is the most direct and fast backup method, but the disadvantage is that incremental backup can not be realized basically. You must make sure that these tables are not used when backing up. If a table is being modified by the server while it is being copied, replication is invalid. When backing up files, it is best to shut down the server and then restart the server.

Mysqlhotcopy is suitable for the backup of small databases with a small amount of data. You can use the mysqlhotcopy program to make a full backup once a day. Mysqldump exports datasheets into SQL script files, which is relatively appropriate when upgrading between different MySQL versions, which is the most commonly used backup method. Mysqldump is slower than copying directly. That is, all the data in memory is flushed to disk and the data table is locked to ensure that no new data is written during the replication process. The data backed up by this method is also very simple to recover and directly copied back to the original database.

Which logs should be opened at ordinary times?

Logging not only affects the performance of MySQL, but also takes up a lot of disk space. Therefore, if not necessary, log should be opened as little as possible. Depending on the environment in which you use it, you can consider opening different logs. For example, if you optimize inefficient statements in the development environment, you can enable the slow query log; if you need to record all the query operations of the user, you can open the general query log; if you need to record changes in the data, you can open the binary log; error log is enabled by default.

At this point, I believe you have a deeper understanding of "SQL database skills", you might as well come to the actual operation of it! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.