Mysql in journals and communities LJ

mysql in entries

shantanuo
2 years ago

python script to automate incremental backup using percona xtrabackup

!mkdir /tmp/inc1/ # take the first full backup and save it to /tmp/inc1 folder import os import subprocess dirname='/tmp/' myl=list() for f in os.listdir(dirname): if os.path.isdir(os.path.join(dirname, f)): myl.append(f) newlist=list() for i in myl: if i.startswith('inc'):…

shantanuo
2 years ago

mysql analysis

Here is the query to know more about the data types used. mysql> select DATA_TYPE, COUNT(*) AS CNT, GROUP_CONCAT(DISTINCT(COLUMN_TYPE)) from information_schema.COLUMNS where TABLE_SCHEMA = 'rechar_db' GROUP BY DATA_TYPE;…

shantanuo
2 years ago

dump data from mysql and import in es

# make sure that config file go_mysql_river.toml file exist in /tmp/ folder and then... docker run -v /tmp/go_mysql_river.toml:/go_mysql_river.toml:ro -d eaglechen/go-mysql-elasticsearch # or using go installation wget https://storage.googleapis.com/golang/go1.7.3.linux-amd64.tar.gz tar -C…

mysql in communities

Found: 143 matches

mysql in blogs

Found: 2724 matches

Name:	{{user.name}}
Journal:	{{user.journal_title}}

Log in

mysql in entries

mysql in communities

mysql in blogs