wachid web id

Check Mysql Databases Size
MariaDB [(none)]> show databases;
+---------------------+
| Database            |
+---------------------+
| information_schema  |
| mysql               |
| performance_schema  |
| portal_final |
+---------------------+
4 rows in set (0.00 sec)

MariaDB [(none)]>
MariaDB [(none)]> SELECT table_schema "DB Name",
    ->         ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB"
    -> FROM information_schema.tables
    -> GROUP BY table_schema;
+---------------------+---------------+
| DB Name             | DB Size in MB |
+---------------------+---------------+
| information_schema  |           0.1 |
| mysql               |           0.6 |
| performance_schema  |           0.0 |
| portal_final        |        2477.2 |
+---------------------+---------------+
4 rows in set, 2 warnings (0.15 sec)

MariaDB [(none)]> exit

Check Mysql Table Size
MariaDB [(none)]> SELECT table_name AS "Table", ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)" FROM information_schema.TABLES WHERE table_schema = "ilk3db" ORDER BY (data_length + index_length) DESC;
+----------------+-----------+
| Table          | Size (MB) |
+----------------+-----------+
| pkk_rambutan   |    598.67 |
| pkk_melon      |    536.73 |
| m_apel         |     19.61 |
| m_jeruk        |      2.34 |
+----------------+-----------+
4 rows in set (0.001 sec)

MariaDB [(none)]>

Create new keyring

C:\Program Files (x86)\HCL\Notes>kyrtool.exe create -k "C:\Program Files (x86)\HCL\Notes\keyring.kyr" -p password

Keyfile C:\Program Files (x86)\HCL\Notes\keyring.kyr created successfully

C:\Program Files (x86)\HCL\Notes>type mykey.key my.pem>server.txt

mykey.key

my.pem

C:\Program Files (x86)\HCL\Notes>kyrtool.exe verify "C:\Program Files (x86)\HCL\Notes\server.txt"

KyrTool v1.1

Successfully read 2048 bit RSA private key
INFO: Successfully read 2 certificates
ERROR: Private key does not match leaf certificate
ERROR: IssuerName of cert 0 does NOT match the SubjectName of cert 1
WARNING: Final certificate in chain is not self-signed

C:\Program Files (x86)\HCL\Notes>kyrtool import all -k "C:\Users\myuser\OneDrive - Office 365 Original\Documents\mykeyring.kyr" -i "C:\Program Files (x86)\HCL\Notes\server.txt"

Using keyring path 'C:\Users\myuser\OneDrive - Office 365 Original\Documents\mykeyring.kyr'
Successfully read 2048 bit RSA private key
SECIssUpdateKeyringPrivateKey succeeded
SECIssUpdateKeyringLeafCert succeeded

C:\Program Files (x86)\HCL\Notes>

C:\Program Files (x86)\HCL\Notes>kyrtool import all -k "C:\Users\myuser\OneDrive - Office 365 Original\Documents\myold.kyr" -i "C:\Program Files (x86)\HCL\Notes\server2.txt"

Using keyring path 'C:\Users\myuser\OneDrive - Office 365 Original\Documents\myold.kyr'
Successfully read 2048 bit RSA private key
SECIssUpdateKeyringPrivateKey succeeded
SECIssUpdateKeyringLeafCert succeeded

C:\Program Files (x86)\HCL\Notes>