list of tz database time zones

The most basic requirement for a date command to display time in different time zones is to display the date and time in your time zone. But what if you have users across time zones? Or if you have friends or colleagues in different regions? You

This is a creation in Article, where the information may have evolved or changed. 1. Preface Time includes time values and time zones, and there are incomplete and ambiguous times when you do not include timezone information. When transmitting or

When a user of an application is spread all over the world, the Code of the program is not necessarily dealing with the time zone. The server-side timing task for the user needs to be set to the time zone of the user. In glow nurture, a typical

Use of the mysqldump command 1. Export all libraries System command Line Mysqldump-uusername-ppassword--all-databases > All.sql 2. Import all libraries MySQL command line Mysql>source All.sql; 3. Export some libraries System command Line

A few days ago encountered such a business scenario, the database runs in the Docker, the Docker city is UTC so it is 8 hours away from the Beijing time. However, you cannot rerun a container, only to ensure that the database is running, and to copy

1. Why back up the database? Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses. The more important the data is, the more frequently the data changes, and the more frequently backup is

Mydumper/myloader Usage Details, mydumpermyloaderMydumper installation: Installing1. mydumper backup 1. Enable 16 Backup processes to back up all the databases and binary log files to the specified

Mysqldumper This backup tool is a good point is obvious, that is, can be concurrent backup, faster than Mysqldump, another is the backup table is a separate file, restore a single table will be very convenient (table structure and data files are

Mydumper principle and mydumper PrincipleInstallation of mydumper: http://www.cnblogs.com/lizhi221/p/7010174.htmlMydumper Introduction MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a

On the first day of New Year, wish all the databases are safe!Look directly at the installation process, the lack of the package of their own see the readme installed.[Email protected] local]# TAR-XVF