vland blog

  There are numerous online courses for network security, most of which are paid courses, but there are also some open source or government funded free quality courses open to the public. For novices, computer students, administrators and even some junior security professionals who are eager to strengthen their network security knowledge, excellent free online courses are undoubtedly a good choice to improve their personal security literacy during the epidemic. Here are five world-renowned free online courses recommended by network security experts: TryHackMe TryHackMe provides content for novices of network security, covering a wide range of topics, including offensive and defensive security training. TryHackMe also has a “Flag Seizing” exercise, which includes an exercise article written by users to let members know how to deal with and solve problems. There are four difficulty level courses to choose from: For beginners, it is suitable for those who do not have computational kno...

  Data loss prevention is the top priority of businesses of all sizes. The global average cost of a data breach increased by 2.6% from 2021 to 2022, reaching $4.35m as opposed to $4.24m, and 43% of victims involved are small businesses, according to Upguard, a cyber resilience company. Regular data backup helps companies restore data smoothly in the event of human errors, cyberattacks, hardware failure, system crashes, and other disasters. Therefore, having reliable data backups is one of the most preventive and safest measures a small or large business can take to prevent long-term financial damage and reputation hit following a data loss accident. What is backup? Data backup is the act of retaining data in a certain manner so that it may be reused in the event of system failure or other special conditions. In everyday life, we frequently require additional keys for our front door and a spare tire for our automobile. These are the embodiments of the backup concept. Data backup is ...

  I believe that everyone who has used MySQL would like to know how to export databases. This article will introduce some common database export operations of MySQL database in detail and look forward to helping you! Use SELECT… INTO OUTFILE sentences to export data information 1. In the following cases, the data analysis table is shulanxt_ Tbl data information is exported to the/tmp/shulanxt.txt file: MySQL>SELECT * FROM shulanxt_tbl ->INTO OUTFILE ‘/tmp/shulanxt.txt’; You can set the format of data output according to the command options. The following example is the export CSV format: MySQL> SELECT * FROM passwd INTO OUTFILE ‘/tmp/shulanxt.txt’ -> FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“‘ -> LINES TERMINATED BY ‘\r\n’; 2. Export table as original record MySQLDump is an application used by MySQL to convert and store databases. It can generate an SQL script, including the commands CREATE TABLE, INSERT, and so on, which are necessary for building a database from scrat...

  MySQL supports the sub query function since version 4.1. Here are some common ways to write MySQL sub queries: select * from xxx where col = [any|all](select * from xxxx); This can be divided into the writing with and without keywords. When no keyword is added, the sub query statement returns a discrete value (note one). The query statement will use the result of the sub query statement as the condition of its “where” clause. “Any” means that the query statement takes the value returned by the sub query as a range, and queries within this range, similar to the “in” keyword. select * from xxx where col in (select * from xxxx); The “where” clause of a query statement takes the result of a sub query statement as its scope. select row(value1,value2…..) = [any](selectcol1,col2..); The result of the execution of the sub query statement matches the result set of the query. If a match can be found, it returns true. Otherwise, it returns false. The result sets on both sides are a set of d...

Backup is to copy and save important data or files to another place to achieve data synchronization between different hosts. And backups on personal computers or servers are important to prevent data loss. System administrators need to process a large amount of enterprise level data every day, even the data on personal computers, so they need to have a deep understanding of different backup tools. This article will introduce 5 backup tools for you to use on Linux servers or systems. Vinchin Vinchin is a professional provider of data protection solutions for enterprises. It provides a series of data backup, instant recovery, and offsite DR solutions for private cloud, public cloud and hybrid cloud environments. It supports the world’s most mainstream virtual environments including VMware, XenServer/XCP-ng, Hyper-V, RHV/oVirt, OpenStack, Sangfor HCI, Oracle Linux Virtualization Manager and Huawei FusionCompute(KVM). Vinchin Backup Free Edition  is packed with basic VM backup and VM r...