id
name
processing priority
3
site type
0 (generic, awaiting analysis)
review version
11
html import
20 (imported)
first seen date
2024-02-09 10:24:49
expired found date
-
created at
2024-06-03 04:10:34
updated at
2025-12-27 03:18:39
length
7
crc
44455
tld
706
nm parts
0
nm random digits
0
nm rare letters
0
is subdomain of id
-
previous id
0
replaced with id
0
related id
-
dns primary id
dns alternative id
0
lifecycle status
0 (unclassified, or currently active)
deleted subdomains
0
page imported products
0
page imported random
0
page imported parking
0
count skipped due to recent timeouts on the same server IP
0
count content received but rejected due to 11-799
0
count dns errors
0
count cert errors
0
count timeouts
0
count http 429
0
count http 404
0
count http 403
0
count http 5xx
0
next operation date
-
server bits
—
server ip
-
mp import status
20
mp rejected date
-
mp saved date
-
mp size orig
53762
mp size raw text
23898
mp inner links count
72
mp inner links status
20 (imported)
title
description
凡出言，信为先；诈与妄，奚可焉。
image
site name
author
updated
2025-12-14 16:35:10
raw text
也就这样， 技术 在线工具 也就这样， 凡出言，信为先；诈与妄，奚可焉。 搜索关键字 搜索 首页 归档 神器 关于 sqlite3导入到mysql 作者: 小子 时间: July 10, 2017 分类: Linux 13 条评论 背景 使用magenetico抓取磁力链接，由于它使用的是sqlite3, 文件会越来越大，而且不支持分布式；所以需要将其改造成MySQL，在迁移之前需要将已经抓取的15G数据导入到MySQL 从sqlite3文件dump出sql sqlite3 database.sqlite3 sqlite3> .output /path/to/dump.sql sqlite3> .dump sqlite3> .exit 切分文件 文件比较大的时候，很有导入到一半的时候失败，这个时候需要从失败的行开始切分出一个新的sql文件来 awk '{if (NR>=6240863) print $0>"dump_part.sql"}' dump.sql mysql参数修改 [mysqld] max_allowed_packet = 100M sql兼容, 符号替换 # 1. 删除不包含 INSERT INTO 的行 # 2. 替换表名 wrap # 3. 替换 hex sed '/INSERT INTO/!d;s/"table1"/`table1`/;s/"table2"/`table2`/;s/,X/,/' dump.sql 导入到MySQL # 加上 force 参数, 防止部分有问题的sql阻止导入 mysql -uroot -p -f magnet < dump.sql 引用 How To Use The SQLite Dump Command 更好使用开发工具 作者: 小子 时间: June 4, 2017 分类: Default 3 条评论 这是在团队内部做的一个分享，PPT见附件 键盘设置 开发工具集合 Bash/Zsh快捷键 iTerm自定义快捷键 iTerm快捷键 更好的展...
redirect type
0 (-)
block type
0 (no issues)
detected language
1 (English)
category id
index version
2025110801
spam phrases
0
text nonlatin
2952
text cyrillic
0
text characters
14588
text words
2339
text unique words
978
text lines
849
text sentences
13
text paragraphs
27
text words per sentence
179
text matched phrases
5
text matched dictionaries
1
links self subdomains
0
links other subdomains
links other domains
8 - tool.lu, usr.im, sqlitetutorial.net, jianshu.com, typecho.org
links spam adult
0
links spam random
0
links spam expired
0
links ext activities
0
links ext ecommerce
0
links ext finance
0
links ext crypto
0
links ext booking
0
links ext news
0
links ext leaks
0
links ext ugc
2
links ext klim
0
links ext generic
0
dol status
0
dol updated
2025-12-14 16:35:10
rss path
rss status
32 (unknown)
rss found date
2024-03-01 16:19:03
rss size orig
29785
rss items
10
rss spam phrases
0
rss detected language
1 (English)
inbefore feed id
-
inbefore status
0 (new)
sitemap path
sitemap status
1 (priority 1 already searched, no matches found)
sitemap review version
1
sitemap urls count
0
sitemap urls adult
0
sitemap filtered products
0
sitemap filtered videos
0
sitemap found date
-
sitemap process date
2024-07-03 03:39:16
sitemap first import date
-
sitemap last import date
-