Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

.info.sqlite にカウンターが入っているのでコンフリクトしまくり #112

Open
kujirahand opened this issue Dec 5, 2024 · 2 comments
Open

.info.sqlite にカウンターが入っているのでコンフリクトしまくり #112

kujirahand opened this issue Dec 5, 2024 · 2 comments

Comments

@kujirahand
Copy link
Owner

.info.sqlite にカウンターが入っているのでコンフリクトしまくり
カウンターは別のファイルに移す
@kujirahand
Copy link
Owner Author

kujirahand commented Dec 5, 2024 •
edited
Loading

カウンターの移行　スクリプト

カウンターの内容を取り出す

sqlite3 .info.sqlite .dump > counter_log.sql

新しいDBにカウンターを移す

sqlite3 subdb.sqlite <<EOF
DELETE FROM counter;
DELETE FROM counter_month;
.read counter_log.sql
EOF

kujirahand added a commit that referenced this issue Dec 5, 2024
@kujirahand
.info.sqlite からカウンターをsubdb.sqliteに移行 #112
7fdb77f
@kujirahand
Copy link
Owner Author

script/move_counter.php を作成した
ただし、popular プラグインがまだ未対応

kujirahand added a commit that referenced this issue Dec 19, 2024
@kujirahand
updated popular plugin for counter db #112
a8b6425
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@kujirahand