迹忆客 EN >

Backing up your database is a very important system administration task that should usually cron be run from a job at scheduled intervals. We will use mysqldump the dump utility that comes with mysql to dump the contents of the database to...

Comma-separated value files ( CSV ) are a way to transfer data between applications. Databases such as MySQL and spreadsheet software such as Excel both support importing and exporting via CSV , so we can use CSV files to exchange data betw...

There are many reasons why we would want to restore a database from a backup file... but we should also test it on a test server to make sure our database backup is working properly. The syntax is as follows: mysql -h hostname -u username -...

Kubernetes support for stateful applications has matured considerably over the past few years. It is now possible to co-locate your database within your cluster, allowing it to benefit from the same scalability as your other workloads. MySQ...

Backing up MySQL isn't hard—you just run mysqldump and output to a file —but it's also not really designed for a production environment. At first, running mysqldump took only a few seconds so everything being locked wasn't a big deal, b...

Oracle's MySQL Operator for Kubernetes is a convenient way to automatically configure a MySQL database within a cluster. One of the key features of the Operator is the integrated automatic backup support for increased resiliency. The backup...

utf8mb4 Fortunately, MySQL 5.5.3 (released in early 2010) introduced a utf8mb4 new encoding called which maps to proper UTF-8 and thus fully supports Unicode, including astral symbols. Step 1: Create a backup Create a backup of all database...

Are you using MySQL's utf8 character set in your database ? In this article, I'll explain why you should switch to utf8mb4 , and how to do it. UTF-8 The UTF-8 encoding can represent every symbol in the Unicode character set, ranging from U+...

The other day I was testing a feature on my development box when I realized that my local data was indeed out of date and I needed some fresh data from production if I wanted to make any progress with my testing. The problem is that our mai...

By default, MySQL only allows localhost connections from addresses. The configuration file is usually in /etc/mysql/my.cnf We need to bind-address comment out the line so it looks like this: - #bind-address = 127.0.0.1 + bind-address = 127....

One of the best ways to speed up your Web application is to enable query caching in your database, which caches frequently used SQL queries in memory so that the next page that makes the same request is almost instantaneous. What makes this...

For each database, we should set root the or sa password to something other than the default unless we want to get hacked. For mysql, the system administrator user is called root. We will use the mysql mysqladmin utility from the command li...

Unusually slow queries are one of the most common MySQL performance issues. Queries that perform acceptably in development may falter under the pressure of a production workload. Large applications may run hundreds of unique database querie...

Database backups are one of those things that just keep getting bigger and bigger until they consume all the physical material in the world. Unlike reality TV, we can easily delete things from our databases to make the backups smaller. But...

请注意 , which is not very secure and should only be used on local development boxes where we don't want to set up personal permissions but still need to connect from other machines. To configure this feature, we need to % update the mys...