MySQL Master-Master-Slave Replication on Oracle VM VirtualBox.pdf
- 5月 29 週三 201917:14
MySQL Master-Master-Slave Replication Setup on Oracle VM VirtualBox 5.2
- 5月 29 週三 201912:27
2019/05/29 教會晨更信息摘要
在這彎曲悖謬的世代裡,有些罪被美化為正當的,然而罪的後果最終一定會帶來神的審判。
求主讓我們不縱容罪,也不藐視神的恩慈,而是行神眼中看為正的事,住在耶和華的殿中,享受上帝的美好!
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190529.mp3 】
求主讓我們不縱容罪,也不藐視神的恩慈,而是行神眼中看為正的事,住在耶和華的殿中,享受上帝的美好!
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190529.mp3 】
- 5月 23 週四 201915:19
Useful MySQL / MariaDB Backup and Restore Tools - mydumper & myloader
Useful MySQL / MariaDB Backup and Restore Tools - mydumper & myloader
☉ Download the latest "mydumper" RPM from the following URL:
[root@MariaDB ~]# cd /source
[root@MariaDB source]# wget --no-check-certificate \
https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-2.el7.x86_64.rpm
--2019-02-25 13:21:45-- https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-2.el7.x86_64.rpm
Resolving github.com (github.com)... 192.30.253.112
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/45695616/79bc2fe6-5cfe-11e8-9ac3-8bd5468930ca?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190523%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190523T053611Z&X-Amz-Expires=300&X-Amz-Signature=68f79dc329bde8aabb0346279a787976974eb9cb4bebb76418bf57c27fb88d71&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dmydumper-0.9.5-2.el7.x86_64.rpm&response-content-type=application%2Foctet-stream [following]
--2019-02-25 13:21:46-- https://github-production-release-asset-2e65be.s3.amazonaws.com/45695616/79bc2fe6-5cfe-11e8-9ac3-8bd5468930ca?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190523%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190523T053611Z&X-Amz-Expires=300&X-Amz-Signature=68f79dc329bde8aabb0346279a787976974eb9cb4bebb76418bf57c27fb88d71&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dmydumper-0.9.5-2.el7.x86_64.rpm&response-content-type=application%2Foctet-stream
Resolving github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)... 52.216.131.3
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|52.216.131.3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1688520 (1.6M) [application/octet-stream]
Saving to: ‘mydumper-0.9.5-2.el7.x86_64.rpm’
☉ Download the latest "mydumper" RPM from the following URL:
[root@MariaDB ~]# cd /source
[root@MariaDB source]# wget --no-check-certificate \
https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-2.el7.x86_64.rpm
--2019-02-25 13:21:45-- https://github.com/maxbube/mydumper/releases/download/v0.9.5/mydumper-0.9.5-2.el7.x86_64.rpm
Resolving github.com (github.com)... 192.30.253.112
Connecting to github.com (github.com)|192.30.253.112|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://github-production-release-asset-2e65be.s3.amazonaws.com/45695616/79bc2fe6-5cfe-11e8-9ac3-8bd5468930ca?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190523%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190523T053611Z&X-Amz-Expires=300&X-Amz-Signature=68f79dc329bde8aabb0346279a787976974eb9cb4bebb76418bf57c27fb88d71&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dmydumper-0.9.5-2.el7.x86_64.rpm&response-content-type=application%2Foctet-stream [following]
--2019-02-25 13:21:46-- https://github-production-release-asset-2e65be.s3.amazonaws.com/45695616/79bc2fe6-5cfe-11e8-9ac3-8bd5468930ca?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIAIWNJYAX4CSVEH53A%2F20190523%2Fus-east-1%2Fs3%2Faws4_request&X-Amz-Date=20190523T053611Z&X-Amz-Expires=300&X-Amz-Signature=68f79dc329bde8aabb0346279a787976974eb9cb4bebb76418bf57c27fb88d71&X-Amz-SignedHeaders=host&actor_id=0&response-content-disposition=attachment%3B%20filename%3Dmydumper-0.9.5-2.el7.x86_64.rpm&response-content-type=application%2Foctet-stream
Resolving github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)... 52.216.131.3
Connecting to github-production-release-asset-2e65be.s3.amazonaws.com (github-production-release-asset-2e65be.s3.amazonaws.com)|52.216.131.3|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1688520 (1.6M) [application/octet-stream]
Saving to: ‘mydumper-0.9.5-2.el7.x86_64.rpm’
- 5月 21 週二 201911:12
MariaDB IP Address Conversion Functions
MariaDB IP Address Conversion Functions:
########
# IPV4:
########
-- Address To Number:
MariaDB [test]> select inet_aton('10.0.2.15');
+------------------------+
| inet_aton('10.0.2.15') |
+------------------------+
| 167772687 |
+------------------------+
1 row in set (0.001 sec)
########
# IPV4:
########
-- Address To Number:
MariaDB [test]> select inet_aton('10.0.2.15');
+------------------------+
| inet_aton('10.0.2.15') |
+------------------------+
| 167772687 |
+------------------------+
1 row in set (0.001 sec)
- 5月 21 週二 201910:33
MariaDB Unix Time Conversion Functions
MariaDB Unix Time Conversion Functions:
MariaDB [test]> select unix_timestamp('2019-05-21 09:00:00');
+---------------------------------------+
| unix_timestamp('2019-05-21 09:00:00') |
+---------------------------------------+
| 1558400400 |
+---------------------------------------+
1 row in set (0.001 sec)
MariaDB [test]> select unix_timestamp('2019-05-21 09:00:00');
+---------------------------------------+
| unix_timestamp('2019-05-21 09:00:00') |
+---------------------------------------+
| 1558400400 |
+---------------------------------------+
1 row in set (0.001 sec)
- 5月 14 週二 201912:13
2019/05/14 教會晨更信息摘要
主是有活水的泉源,恩典夠我們用的神。若我們離棄神倚靠自己鑿池子,是破裂、祝福留不住的池子。
讓我們住在活水泉源,倚靠神的恩典,離開自己鑿池子的人生;一生誇耀的不是自己,乃是讓人看見:
我們一生有說不盡從神而來的恩典!
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190514.mp3 】
讓我們住在活水泉源,倚靠神的恩典,離開自己鑿池子的人生;一生誇耀的不是自己,乃是讓人看見:
我們一生有說不盡從神而來的恩典!
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190514.mp3 】
- 5月 08 週三 201916:51
Use adb command to access SQLite database [Android Studio]
C:\Users\test\AppData\Local\Android\Sdk\platform-tools>adb devices
List of devices attached
emulator-5554 device
C:\Users\test\AppData\Local\Android\Sdk\platform-tools>adb kill-server
List of devices attached
emulator-5554 device
C:\Users\test\AppData\Local\Android\Sdk\platform-tools>adb kill-server
- 5月 08 週三 201912:26
2019/05/08 教會晨更信息摘要
基督是一切關係的中心。
不論任何一種關係,都是從耶穌而來,耶穌是主。
我們在各樣的關係上都有不同的糾結,我們並不完美,但為了主的緣故積極去愛、去順服,讓神來掌管一切,即便不容易,卻能讓一切變得簡單。
求神在我們生命中的每個關係裡掌權,使我們能夠活出彼此和睦、彼此相愛的生命.
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190508.mp3 】
不論任何一種關係,都是從耶穌而來,耶穌是主。
我們在各樣的關係上都有不同的糾結,我們並不完美,但為了主的緣故積極去愛、去順服,讓神來掌管一切,即便不容易,卻能讓一切變得簡單。
求神在我們生命中的每個關係裡掌權,使我們能夠活出彼此和睦、彼此相愛的生命.
【 線上收聽 >> http://www.changelife.org.tw/data/files/morning_bible_study/20190508.mp3 】
- 5月 06 週一 201912:18
2019/05/06 教會晨更信息摘要
肉身尚存的一天,就必須面對肉體所具有的邪情私欲。基督徒要明確地認識到,我們不屬於肉體的私欲,乃是屬於基督耶穌。
求神幫助我們,當我們對抗肉身的邪情之時,要站在基督耶穌而非世界文化那一方,以聖靈的大能治死肉體的情慾!
本日線上晨更:
http://www.changelife.org.tw/data/files/morning_bible_study/20190506.mp3
求神幫助我們,當我們對抗肉身的邪情之時,要站在基督耶穌而非世界文化那一方,以聖靈的大能治死肉體的情慾!
本日線上晨更:
http://www.changelife.org.tw/data/files/morning_bible_study/20190506.mp3
- 4月 30 週二 201912:26
2019/04/30 教會晨更信息摘要
教會是神的心意。
當教會彼此相愛的時候,愛的土壤會是神蹟的土壤!
求神幫助我們,不要讓特會取代我們的教會生活。
讓我們委身在小組,彼此認罪、互相代求,愛我們的小組和教會!
本日線上晨更: http://www.changelife.org.tw/data/files/morning_bible_study/20190430.mp3
當教會彼此相愛的時候,愛的土壤會是神蹟的土壤!
求神幫助我們,不要讓特會取代我們的教會生活。
讓我們委身在小組,彼此認罪、互相代求,愛我們的小組和教會!
本日線上晨更: http://www.changelife.org.tw/data/files/morning_bible_study/20190430.mp3
