MySQL – Adamhuan's Data Center – 【逻辑驱动数据】

MariaDB：升级（5.5.6 –> 10.4.1） on CentOS 7

首先，看看当前数据库的信息。

[root@oracleme ~]# service mariadb status
Redirecting to /bin/systemctl status mariadb.service
● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: active (running) since Fri 2019-01-18 22:19:27 CST; 5s ago
  Process: 20862 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)
  Process: 20830 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)
 Main PID: 20861 (mysqld_safe)
    Tasks: 21
   CGroup: /system.slice/mariadb.service
           ├─20861 /bin/sh /usr/bin/mysqld_safe --basedir=/usr
           └─21227 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysq...

Jan 18 22:19:24 vesta.gds-services.com systemd[1]: Starting MariaDB database ...
Jan 18 22:19:25 vesta.gds-services.com mariadb-prepare-db-dir[20830]: Databas...
Jan 18 22:19:25 vesta.gds-services.com mysqld_safe[20861]: 190118 22:19:25 my...
Jan 18 22:19:25 vesta.gds-services.com mysqld_safe[20861]: 190118 22:19:25 my...
Jan 18 22:19:27 vesta.gds-services.com systemd[1]: Started MariaDB database s...
Hint: Some lines were ellipsized, use -l to show in full.
[root@oracleme ~]# 
[root@oracleme ~]# mysql -V
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1
[root@oracleme ~]# 
[root@oracleme ~]# mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 5.5.60-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select version();
+----------------+
| version()      |
+----------------+
| 5.5.60-MariaDB |
+----------------+
1 row in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| admin_default      |
| mysql              |
| performance_schema |
| roundcube          |
| yuyihuan_itop      |
+--------------------+
6 rows in set (0.00 sec)

MariaDB [(none)]> 
MariaDB [(none)]> select user,host from mysql.user;
+-----------------+-----------+
| user            | host      |
+-----------------+-----------+
| admin_default   | %         |
| yuyihuan_itroot | %         |
| admin_default   | localhost |
| root            | localhost |
| roundcube       | localhost |
| yuyihuan_itroot | localhost |
+-----------------+-----------+
6 rows in set (0.00 sec)

MariaDB [(none)]>

[root@oracleme ~]# service mariadb status

Redirecting to /bin/systemctl status mariadb.service

● mariadb.service - MariaDB database server

Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)

Active: active (running) since Fri 2019-01-18 22:19:27 CST; 5s ago

Process: 20862 ExecStartPost=/usr/libexec/mariadb-wait-ready $MAINPID (code=exited, status=0/SUCCESS)

Process: 20830 ExecStartPre=/usr/libexec/mariadb-prepare-db-dir %n (code=exited, status=0/SUCCESS)

Main PID: 20861 (mysqld_safe)

Tasks: 21

CGroup: /system.slice/mariadb.service

├─20861 /bin/sh /usr/bin/mysqld_safe --basedir=/usr

└─21227 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysq...

Jan 18 22:19:24 vesta.gds-services.com systemd[1]: Starting MariaDB database ...

Jan 18 22:19:25 vesta.gds-services.com mariadb-prepare-db-dir[20830]: Databas...

Jan 18 22:19:25 vesta.gds-services.com mysqld_safe[20861]: 190118 22:19:25 my...

Jan 18 22:19:27 vesta.gds-services.com systemd[1]: Started MariaDB database s...

Hint: Some lines were ellipsized, use -l to show in full.

[root@oracleme ~]#

[root@oracleme ~]# mysql -V

mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1

[root@oracleme ~]#

[root@oracleme ~]# mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 2

Server version: 5.5.60-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> select version();

+----------------+

| version() |

+----------------+

| 5.5.60-MariaDB |

+----------------+

1 row in set (0.00 sec)

MariaDB [(none)]>

MariaDB [(none)]> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| admin_default |

| mysql |

| performance_schema |

| roundcube |

| yuyihuan_itop |

+--------------------+

6 rows in set (0.00 sec)

MariaDB [(none)]>

MariaDB [(none)]> select user,host from mysql.user;

+-----------------+-----------+

| user | host |

+-----------------+-----------+

| admin_default | % |

| yuyihuan_itroot | % |

| admin_default | localhost |

| root | localhost |

| roundcube | localhost |

| yuyihuan_itroot | localhost |

+-----------------+-----------+

6 rows in set (0.00 sec)

MariaDB [(none)]>

备份原库：

[root@oracleme mysql_data]# pwd
/backup/mysql_data
[root@oracleme mysql_data]# 
[root@oracleme mysql_data]# ls -ltr
total 0
[root@oracleme mysql_data]# 
[root@oracleme mysql_data]# mysqldump -u root --all-databases > mariadb_backup_data_all_db.sql
[root@oracleme mysql_data]# 
[root@oracleme mysql_data]# ls -ltr
total 520
-rw-r--r--. 1 root root 530379 Jan 18 22:21 mariadb_backup_data_all_db.sql
[root@oracleme mysql_data]# 
[root@oracleme mysql_data]# du -sh *
520K    mariadb_backup_data_all_db.sql
[root@oracleme mysql_data]# 

[root@oracleme mysql_data]# cp -rf /etc/my.cnf* .
[root@oracleme mysql_data]# ls -ltr
total 524
-rw-r--r--. 1 root root 530379 Jan 18 22:21 mariadb_backup_data_all_db.sql
drwxr-xr-x. 2 root root     67 Jan 18 22:23 my.cnf.d
-rw-r--r--. 1 root root    737 Jan 18 22:23 my.cnf
[root@oracleme mysql_data]# 
[root@oracleme mysql_data]# ls -ltr my.cnf.d/
total 12
-rw-r--r--. 1 root root 744 Jan 18 22:23 server.cnf
-rw-r--r--. 1 root root 232 Jan 18 22:23 mysql-clients.cnf
-rw-r--r--. 1 root root 295 Jan 18 22:23 client.cnf
[root@oracleme mysql_data]#

[root@oracleme mysql_data]# pwd

/backup/mysql_data

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# ls -ltr

total 0

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# mysqldump -u root --all-databases > mariadb_backup_data_all_db.sql

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# ls -ltr

total 520

-rw-r--r--. 1 root root 530379 Jan 18 22:21 mariadb_backup_data_all_db.sql

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# du -sh *

520K mariadb_backup_data_all_db.sql

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# cp -rf /etc/my.cnf* .

[root@oracleme mysql_data]# ls -ltr

total 524

-rw-r--r--. 1 root root 530379 Jan 18 22:21 mariadb_backup_data_all_db.sql

drwxr-xr-x. 2 root root 67 Jan 18 22:23 my.cnf.d

-rw-r--r--. 1 root root 737 Jan 18 22:23 my.cnf

[root@oracleme mysql_data]#

[root@oracleme mysql_data]# ls -ltr my.cnf.d/

total 12

-rw-r--r--. 1 root root 744 Jan 18 22:23 server.cnf

-rw-r--r--. 1 root root 232 Jan 18 22:23 mysql-clients.cnf

-rw-r--r--. 1 root root 295 Jan 18 22:23 client.cnf

[root@oracleme mysql_data]#

配置YUM文件：

[root@oracleme ~]# ls -ltr /etc/yum.repos.d/
total 96
-rw-r--r--. 1 root root 1050 Oct  3  2017 epel-testing.repo
-rw-r--r--. 1 root root  951 Oct  3  2017 epel.repo
-rw-r--r--. 1 root root 5701 Nov 23 21:16 CentOS-Vault.repo
-rw-r--r--. 1 root root 1331 Nov 23 21:16 CentOS-Sources.repo
-rw-r--r--. 1 root root  630 Nov 23 21:16 CentOS-Media.repo
-rw-r--r--. 1 root root  314 Nov 23 21:16 CentOS-fasttrack.repo
-rw-r--r--. 1 root root  649 Nov 23 21:16 CentOS-Debuginfo.repo
-rw-r--r--. 1 root root 1309 Nov 23 21:16 CentOS-CR.repo
-rw-r--r--. 1 root root 1664 Nov 23 21:16 CentOS-Base.repo
-rw-r--r--. 1 root root  750 Dec 22 01:50 remi-safe.repo
-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php73.repo
-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php72.repo
-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php71.repo
-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php70.repo
-rw-r--r--. 1 root root  456 Dec 22 01:50 remi-php54.repo
-rw-r--r--. 1 root root  446 Dec 22 01:50 remi-glpi94.repo
-rw-r--r--. 1 root root  446 Dec 22 01:50 remi-glpi93.repo
-rw-r--r--. 1 root root  446 Dec 22 01:50 remi-glpi92.repo
-rw-r--r--. 1 root root  446 Dec 22 01:50 remi-glpi91.repo
-rw-r--r--. 1 root root 2605 Jan 18 17:16 remi.repo
-rw-r--r--. 1 root root   99 Jan 18 17:16 nginx.repo
-rw-r--r--. 1 root root  145 Jan 18 17:16 vesta.repo
-rw-r--r--. 1 root root   87 Jan 18 22:26 mariadb.repo
[root@oracleme ~]# 
[root@oracleme ~]# cat /etc/yum.repos.d/mariadb.repo 
[mariadb]
name=MariaDB
baseurl=http://yum.mariadb.org/10.4.1/centos7-amd64/
gpgcheck=0
[root@oracleme ~]# 
[root@oracleme ~]# vi /etc/yum.conf 
[root@oracleme ~]# 
[root@oracleme ~]# cat /etc/yum.conf | grep keepcache
keepcache=1
[root@oracleme ~]#

[root@oracleme ~]# ls -ltr /etc/yum.repos.d/

total 96

-rw-r--r--. 1 root root 1050 Oct 3 2017 epel-testing.repo

-rw-r--r--. 1 root root 951 Oct 3 2017 epel.repo

-rw-r--r--. 1 root root 5701 Nov 23 21:16 CentOS-Vault.repo

-rw-r--r--. 1 root root 1331 Nov 23 21:16 CentOS-Sources.repo

-rw-r--r--. 1 root root 630 Nov 23 21:16 CentOS-Media.repo

-rw-r--r--. 1 root root 314 Nov 23 21:16 CentOS-fasttrack.repo

-rw-r--r--. 1 root root 649 Nov 23 21:16 CentOS-Debuginfo.repo

-rw-r--r--. 1 root root 1309 Nov 23 21:16 CentOS-CR.repo

-rw-r--r--. 1 root root 1664 Nov 23 21:16 CentOS-Base.repo

-rw-r--r--. 1 root root 750 Dec 22 01:50 remi-safe.repo

-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php73.repo

-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php72.repo

-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php71.repo

-rw-r--r--. 1 root root 1314 Dec 22 01:50 remi-php70.repo

-rw-r--r--. 1 root root 456 Dec 22 01:50 remi-php54.repo

-rw-r--r--. 1 root root 446 Dec 22 01:50 remi-glpi94.repo

-rw-r--r--. 1 root root 446 Dec 22 01:50 remi-glpi93.repo

-rw-r--r--. 1 root root 446 Dec 22 01:50 remi-glpi92.repo

-rw-r--r--. 1 root root 446 Dec 22 01:50 remi-glpi91.repo

-rw-r--r--. 1 root root 2605 Jan 18 17:16 remi.repo

-rw-r--r--. 1 root root 99 Jan 18 17:16 nginx.repo

-rw-r--r--. 1 root root 145 Jan 18 17:16 vesta.repo

-rw-r--r--. 1 root root 87 Jan 18 22:26 mariadb.repo

[root@oracleme ~]#

[root@oracleme ~]# cat /etc/yum.repos.d/mariadb.repo

[mariadb]

name=MariaDB

baseurl=http://yum.mariadb.org/10.4.1/centos7-amd64/

gpgcheck=0

[root@oracleme ~]#

[root@oracleme ~]# vi /etc/yum.conf

[root@oracleme ~]#

[root@oracleme ~]# cat /etc/yum.conf | grep keepcache

keepcache=1

[root@oracleme ~]#

刷新YUM：[……]

发表于： 2019年1月19日 2019年1月19日
作者： Adamhuan
分类： MariaDB, MySQL
标签： 10.4.1, 5.5.6, 7, centos, centos7, Linux, MariaDB, MySQL, Update, Upgrade, 升级
发表评论: MariaDB：升级（5.5.6 –> 10.4.1） on CentOS 7

MySQL 8，error：Failed to connect to mysql server using user “root” and password “***”: Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

有时候你会遇到如题所示的问题，具体如下：

在安装SEAFILE 6.2.5的时候，如果对应的MySQL是8.0的，就会出现上述问题：

[root@centerbase seafile-server-6.2.5]# sh setup-seafile-mysql.sh 
Checking python on this machine ...
  Checking python module: setuptools ... Done.
  Checking python module: python-imaging ... Done.
  Checking python module: python-mysqldb ... Done.

-----------------------------------------------------------------
This script will guide you to setup your seafile server using MySQL.
Make sure you have read seafile server manual at

        https://github.com/haiwen/seafile/wiki

Press ENTER to continue
-----------------------------------------------------------------


What is the name of the server? It will be displayed on the client.
3 - 15 letters or digits
[ server name ] centerbase

What is the ip or domain of the server?
For example: www.mycompany.com, 192.168.1.101
[ This server's ip or domain ] 192.168.159.254

Where do you want to put your seafile data?
Please use a volume with enough free space
[ default "/seafile_root/seafile-data" ] 

Which port do you want to use for the seafile fileserver?
[ default "8082" ] 

-------------------------------------------------------
Please choose a way to initialize seafile databases:
-------------------------------------------------------

[1] Create new ccnet/seafile/seahub databases
[2] Use existing ccnet/seafile/seahub databases

[ 1 or 2 ] 
-------------------------------------------------------
Please choose a way to initialize seafile databases:
-------------------------------------------------------

[1] Create new ccnet/seafile/seahub databases
[2] Use existing ccnet/seafile/seahub databases

[ 1 or 2 ] 1

What is the host of mysql server?
[ default "localhost" ] 

What is the port of mysql server?
[ default "3306" ] 

What is the password of the mysql root user?
[ root password ] 

verifying password of user root ...  
verifying password of user root ...  
Failed to connect to mysql server using user "root" and password "***": Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

What is the password of the mysql root user?
[ root password ]

[root@centerbase seafile-server-6.2.5]# sh setup-seafile-mysql.sh

Checking python on this machine ...

Checking python module: setuptools ... Done.

Checking python module: python-imaging ... Done.

Checking python module: python-mysqldb ... Done.

-----------------------------------------------------------------

This script will guide you to setup your seafile server using MySQL.

Make sure you have read seafile server manual at

https://github.com/haiwen/seafile/wiki

Press ENTER to continue

-----------------------------------------------------------------

What is the name of the server? It will be displayed on the client.

3 - 15 letters or digits

[ server name ] centerbase

What is the ip or domain of the server?

For example: www.mycompany.com, 192.168.1.101

[ This server's ip or domain ] 192.168.159.254

Where do you want to put your seafile data?

Please use a volume with enough free space

[ default "/seafile_root/seafile-data" ]

Which port do you want to use for the seafile fileserver?

[ default "8082" ]

-------------------------------------------------------

Please choose a way to initialize seafile databases:

-------------------------------------------------------

[1] Create new ccnet/seafile/seahub databases

[2] Use existing ccnet/seafile/seahub databases

[ 1 or 2 ]

-------------------------------------------------------

Please choose a way to initialize seafile databases:

-------------------------------------------------------

[1] Create new ccnet/seafile/seahub databases

[2] Use existing ccnet/seafile/seahub databases

[ 1 or 2 ] 1

What is the host of mysql server?

[ default "localhost" ]

What is the port of mysql server?

[ default "3306" ]

What is the password of the mysql root user?

[ root password ]

verifying password of user root ...

Failed to connect to mysql server using user "root" and password "***": Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

What is the password of the mysql root user?

[ root password ]

查看下报错中提示的文件：
[crayon-5c42e1554dc4a1693141[……]

Percona Server for MySQL® 8.0：On CentOS 7

Percona，官方网站：https://www.percona.com/
Percona server for MySQL，官方网站：
https://www.percona.com/software/mysql-database/percona-server

下载介质，上传服务器并解压[……]

发表于： 2019年1月15日 2019年1月15日
作者： Adamhuan
分类： MySQL
标签： 7, 8.0, centos, CentOS 7, Install, MySQL, percona, Server, 安装
发表评论: Percona Server for MySQL® 8.0：On CentOS 7

MYSQL MASTER/SLAVE，错误：CANNOT SCHEDULE EVENT QUERY, RELAY-LOG NAME /DATA/MYSQL/BINLOG/DBNODEOSLAVE-RELAY-BIN.001948, POSITION 893170041 TO WORKER THREAD BECAUSE ITS SIZE 24972941 EXCEEDS 16777216 OF SLAVE_PENDING_JOBS_SIZE_MAX.

昨天晚上解决了一个MySQL主从的问题。

具体的笔记发布在了我的内网Wordpress站点上：

————————
Done。

Python：将文本文件的逗号分隔的数据导入MySQL

这是9月份写的一个脚本。

代码如下：

# Import
import os
import linecache
import pymysql

# Variable

# --> File
file_path = r"F:\adamhuan_data\temp_me\2018年9月28日\ICMP0928"
obj_file = open(file_path)
#obj_line = linecache.getline(file_path,22)

total_line_count = len(open(file_path, 'r').readlines())

log_file_path = r"F:\adamhuan_data\temp_me\2018年9月28日\****_Result.txt"
obj_log_file_path = open(log_file_path,"w")

# --> Result
obj_ip_source = obj_ip_target = []

# Function

def do_line_data(single_line_data,record_id):

    # do - step 1
    #list_data_line = list(single_line_data)
    list_data_line = single_line_data.split(',')

    #time = eval(single_line_data.split(',')[1])
    #ip_source = eval(single_line_data.split(',')[2])
    #ip_target = eval(single_line_data.split(',')[3])
    #info = eval(single_line_data.split(',')[5])

    time = single_line_data.split(',')[1]
    ip_source = single_line_data.split(',')[2]
    ip_target = single_line_data.split(',')[3]
    info = ''.join(single_line_data.split(',')[5:])

    # do - step 2
    obj_ip_source.append(ip_source)
    obj_ip_target.append(ip_target)

    # display
    print(single_line_data)
    print("===")
    #print(list_data_line)
    print(record_id)
    print(time)
    print(ip_source)
    print(ip_target)
    print(info)

    # Do MySQL Stuff
    obj_mysql = pymysql.connect(host='127.0.0.1',port= 3306,user = 'root',passwd='****',db='bigfile_job')
    obj_curs = obj_mysql.cursor()
    sql = ""
    do_insert = ""

    #if record_id != 1:

    sql = "insert into ****_import_bigfile(id,time,ip_source,ip_target,info) value ("+str(record_id)+",\""+eval(time)+"\",\""+eval(ip_source)+"\",\""+eval(ip_target)+"\",\""+eval(info)+"\")"
    print(sql)

    #do_insert = obj_curs.execute('insert into ****_import_bigfile(id,time,ip_sorce,ip_targe,info) vaules(%s,%s,%s,%s,%s)',("record_id","time","ip_source","ip_target","info"))
    do_insert = obj_curs.execute(sql)

    # commit
    obj_mysql.commit()

    # close
    obj_curs.close()
    obj_mysql.close()

    # display
    print(do_insert)

def get_full_data():
    id_record = 0
    for line in obj_file:

        # do sth.
        #print("-----")
        if id_record != 0:
            do_line_data(line.strip(),id_record)

        # increase
        id_record = id_record + 1

        # display
        #print("record id: ["+str(id_record)+"]")

    #print("")
    obj_file.close()

# Doing

# ----------------
get_full_data()
#  ----------------

for item in set(obj_ip_source):
    if item != "":
        item_count = obj_ip_source.count(item)
        item_count_percent = format(float(item_count) / total_line_count * 100,'.5f')

        # display and output
        #print("########",file = obj_log_file_path)
        #print("Item: "+item,file = obj_log_file_path)
        #print("Count: "+str(item_count),file = obj_log_file_path)
        #print("Percent: "+item_count_percent+" %",file = obj_log_file_path)
        #print("----",file = obj_log_file_path)
        #print("Total Item Count: " + str(total_line_count),file = obj_log_file_path)

        # MySQL input.
        # Not Here

# Ending

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

# Import

import os

import linecache

import pymysql

# Variable

# --> File

file_path = r"F:\adamhuan_data\temp_me\2018年9月28日\ICMP0928"

obj_file = open(file_path)

#obj_line = linecache.getline(file_path,22)

total_line_count = len(open(file_path, 'r').readlines())

log_file_path = r"F:\adamhuan_data\temp_me\2018年9月28日\****_Result.txt"

obj_log_file_path = open(log_file_path,"w")

# --> Result

obj_ip_source = obj_ip_target = []

# Function

def do_line_data(single_line_data,record_id):

# do - step 1

#list_data_line = list(single_line_data)

list_data_line = single_line_data.split(',')

#time = eval(single_line_data.split(',')[1])

#ip_source = eval(single_line_data.split(',')[2])

#ip_target = eval(single_line_data.split(',')[3])

#info = eval(single_line_data.split(',')[5])

time = single_line_data.split(',')[1]

ip_source = single_line_data.split(',')[2]

ip_target = single_line_data.split(',')[3]

info = ''.join(single_line_data.split(',')[5:])

# do - step 2

obj_ip_source.append(ip_source)

obj_ip_target.append(ip_target)

# display

print(single_line_data)

print("===")

#print(list_data_line)

print(record_id)

print(time)

print(ip_source)

print(ip_target)

print(info)

# Do MySQL Stuff

obj_mysql = pymysql.connect(host='127.0.0.1',port= 3306,user = 'root',passwd='****',db='bigfile_job')

obj_curs = obj_mysql.cursor()

sql = ""

do_insert = ""

#if record_id != 1:

sql = "insert into ****_import_bigfile(id,time,ip_source,ip_target,info) value ("+str(record_id)+",\""+eval(time)+"\",\""+eval(ip_source)+"\",\""+eval(ip_target)+"\",\""+eval(info)+"\")"

print(sql)

#do_insert = obj_curs.execute('insert into ****_import_bigfile(id,time,ip_sorce,ip_targe,info) vaules(%s,%s,%s,%s,%s)',("record_id","time","ip_source","ip_target","info"))

do_insert = obj_curs.execute(sql)

# commit

obj_mysql.commit()

# close

obj_curs.close()

obj_mysql.close()

# display

print(do_insert)

def get_full_data():

id_record = 0

for line in obj_file:

# do sth.

#print("-----")

if id_record != 0:

do_line_data(line.strip(),id_record)

# increase

id_record = id_record + 1

# display

#print("record id: ["+str(id_record)+"]")

#print("")

obj_file.close()

# Doing

# ----------------

get_full_data()

# ----------------

for item in set(obj_ip_source):

if item != "":

item_count = obj_ip_source.count(item)

item_count_percent = format(float(item_count) / total_line_count * 100,'.5f')

# display and output

#print("########",file = obj_log_file_path)

#print("Item: "+item,file = obj_log_file_path)

#print("Count: "+str(item_count),file = obj_log_file_path)

#print("Percent: "+item_count_percent+" %",file = obj_log_file_path)

#print("----",file = obj_log_file_path)

#print("Total Item Count: " + str(total_line_count),file = obj_log_file_path)

# MySQL input.

# Not Here

# Ending

——————————————
Done。