Summer Progress Plan 2: Climb the details of a Top100 movie and store the results in the database

Crawl the top 100 movie information of an eye and store it in the database It's hard for me to make it today. Cry. number picture Full name To star time score Let's put the code below: from urllib import request from bs4 import BeautifulSoup import pymysql conn = pymysql.connect(host = 'localhost', u ...

Posted by amclean on Sun, 06 Oct 2019 04:50:19 -0700

Xtrabackup backup script

Install MySQL mysql-5.7 (yum mode) curl -sSL https://dwz.cn/gfcnHqGS -o install-mysql.sh chmod +x install-mysql.sh ./install-mysql.sh --get-version # View software versions in the repository # Example ./install-mysql.sh --active install --data-dir /home/hadoop/mysql --version 5.7.23 --root-pass 123abc@DEF --help # View Help Inform ...

Posted by jtbaker on Sun, 06 Oct 2019 01:57:33 -0700

Knowledge Reasoning Machine Reproduction Based on jena

Knowledge inference machine reappearing Because csdn grammar support is different from github, you are welcome to visit the GitHub version of this article: https://github.com/JimXiongGM/KnowledgeBasedSearch/blob/master/ knowledge reasoning machine reappears.md Catalog mysql 8.0 preparation Installa ...

Posted by cowfish on Sat, 05 Oct 2019 17:32:53 -0700

Table Analysis of Marketing Module Database: Time-limited Purchase Function

SpringBoot e-commerce project mall (20k+star) address: https://github.com/macrozheng/mall abstract This paper mainly analyzes the relevant functions of the limited time purchase (spike) function, and adopts the form of database table and function comparison. Relevant table structure Time limit purchase form Information used to store time-limit ...

Posted by Ne0_Dev on Sat, 05 Oct 2019 09:31:39 -0700

MySQL Management - Commands to Operate and View Databases

ABSTRACT: This paper mainly studies the common commands of operating and querying database. View the basic information of the database Query all databases Syntax: 1 show databases; Example: 1 mysql> show databases; 2 +--------------------+ 3 | Database | 4 +--------------------+ 5 | information_schema | 6 | m ...

Posted by Inkeye on Sat, 05 Oct 2019 05:12:18 -0700

Deployment of canal based on docker-compose

canal's Origin and Related Introduction To understand the introduction of canal framework, installation and source code, please refer towiki The basic installation process and demo are very clear on the official git. It is strongly recommended to read the related introduction on git. Mysql related s ...

Posted by jdock1 on Fri, 04 Oct 2019 20:53:18 -0700

Implementation of GTID Function Experiments by Binary Installation of MySQL 5.7

Environmental Science: 192.168.205.37: as master server 192.168.205.47: as slave server Edition: OS: centos 7 1810 with mini install mysql-5.7.26-el7-x86_64.tar.gz Purpose: GTID(global transaction ID) global transaction identifier, MySQL 5.6 version began to support, GTID replication, unlike traditional replication (asynchronous delayed re ...

Posted by El_Dudereno on Fri, 04 Oct 2019 18:28:19 -0700

python connects mysql server

python connects mysql clients import pymysql # Import module conn = pymysql.connect( host='127.0.0.1', # Host module port=3306, # Port number user='root',# User name password='123', # Password database='db', # Libraries that need to be connected charset='utf8' # Specify code utf8 ) cursor = conn.cursor() # Get cursor # ...

Posted by alexrait1 on Fri, 04 Oct 2019 18:26:08 -0700

Constructing key pair for remote connection between Linux server and client

Client: 192.168.1.10 Zhangsan userServer: 192.168.1.20 Lisi usersCreate key pairs in the client: [zhangsan@localhost /]$ ssh-keygen -t ecdsa # - t is used to specify algorithm types: ecdsa and dsa Generating public/private ecdsa key pair. Enter file in which to save the key (/home/zhangsan/.ssh/id_ecdsa): # Specify the private key ...

Posted by jack_wetson on Fri, 04 Oct 2019 18:03:27 -0700

Linux Centos 7 - MySQL 5.7 Offline Installation

The internal network is installed by offline package. First, Download Download address: https://dev.mysql.com/downloads/mysql/ After entering the page, click the link on the right. Download the corresponding version. Upload to the server through xftp6 and other tools. II. Installation and Configuration 2.1 Query and uninstall Ma ...

Posted by thoand on Fri, 04 Oct 2019 13:08:04 -0700