株式会社ヴァンデミックシステム

Blog

<スポンサーリンク>

wordpressのバックエンドでは、mysqlが動いてる。
中身ののぞき方的な感じの備忘録的な。

mysqlへのログイン

root@HYPERION:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 632
Server version: 5.5.55-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 
データベース一覧

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| wordpressdb        |
+--------------------+
4 rows in set (0.00 sec)

 
データベース選択

mysql> use wordpressdb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

 
テーブル一覧

mysql> show tables;
+---------------------------+
| Tables_in_wordpressdb     |
+---------------------------+
| wp_ahm_download_stats     |
| wp_ahm_emails             |
| wp_commentmeta            |
| wp_comments               |
| wp_cpd_counter            |
| wp_links                  |
| wp_media_file_manager_log |
| wp_options                |
| wp_postmeta               |
| wp_posts                  |
| wp_term_relationships     |
| wp_term_taxonomy          |
| wp_termmeta               |
| wp_terms                  |
| wp_usermeta               |
| wp_users                  |
| wp_wfu_dbxqueue           |
| wp_wfu_log                |
| wp_wfu_userdata           |
| wp_wpbackitup_job_control |
| wp_wpbackitup_job_items   |
| wp_wpbackitup_job_tasks   |
+---------------------------+
22 rows in set (0.00 sec)

 
カラム一覧

mysql> show columns from wp_terms;
+------------+---------------------+------+-----+---------+----------------+
| Field      | Type                | Null | Key | Default | Extra          |
+------------+---------------------+------+-----+---------+----------------+
| term_id    | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
| name       | varchar(200)        | NO   | MUL |         |                |
| slug       | varchar(200)        | NO   | MUL |         |                |
| term_group | bigint(10)          | NO   |     | 0       |                |
+------------+---------------------+------+-----+---------+----------------+
4 rows in set (0.00 sec)

 
テーマ一覧

mysql> select * from wp_terms;
+---------+---------------------------+--------------------------------------------------------------------------+------------+
| term_id | name                      | slug                                                                     | term_group |
+---------+---------------------------+--------------------------------------------------------------------------+------------+
|       1 | 未分類                    | %e6%9c%aa%e5%88%86%e9%a1%9e                                              |          0 |
|       2 | Windows                   | windows                                                                  |          0 |
|       3 | コマンド                  | %e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89                                     |          0 |
|       4 | Active Directory          | active-directory                                                         |          0 |
|       5 | Windows 10                | windows-10                                                               |          0 |
|       6 | VMware                    | vmware                                                                   |          0 |
|       7 | 資格                      | %e8%b3%87%e6%a0%bc                                                       |          0 |
|       8 | Linux                     | linux                                                                    |          0 |
|       9 | バッチファイル            | %e3%83%90%e3%83%83%e3%83%81%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab          |          0 |
|      10 | バッチファイル            | %e3%83%90%e3%83%83%e3%83%81%e3%83%95%e3%82%a1%e3%82%a4%e3%83%ab-windows  |          0 |
|      11 | post-format-image         | post-format-image                                                        |          0 |
|      12 | 正規表現                  | %e6%ad%a3%e8%a6%8f%e8%a1%a8%e7%8f%be                                     |          0 |
|      13 | 正規表現                  | %e6%ad%a3%e8%a6%8f%e8%a1%a8%e7%8f%be                                     |          0 |
|      14 | Hyper-V                   | hyper-v                                                                  |          0 |
|      15 | zabbix                    | zabbix                                                                   |          0 |
|      16 | フリーツール              | %e3%83%95%e3%83%aa%e3%83%bc%e3%83%84%e3%83%bc%e3%83%ab                   |          0 |
|      17 | Powershell                | powershell                                                               |          0 |
|      18 | Powershell                | powershell-windows                                                       |          0 |
|      19 | EXCEL                     | excel                                                                    |          0 |
|      20 | VBA                       | vba                                                                      |          0 |
|      21 | Firefox                   | firefox                                                                  |          0 |
|      22 | グループポリシー          | %e3%82%b0%e3%83%ab%e3%83%bc%e3%83%97%e3%83%9d%e3%83%aa%e3%82%b7%e3%83%bc |          0 |
|      23 | グループポリシー          | %e3%82%b0%e3%83%ab%e3%83%bc%e3%83%97%e3%83%9d%e3%83%aa%e3%82%b7%e3%83%bc |          0 |
|      24 | WordPress                 | wordpress                                                                |          0 |
|      25 | Internet Explorer         | internet-explorer                                                        |          0 |
|      26 | レジストリ                | %e3%83%ac%e3%82%b8%e3%82%b9%e3%83%88%e3%83%aa                            |          0 |
|      27 | PS3                       | ps3                                                                      |          0 |
|      28 | OwnCloud                  | owncloud                                                                 |          0 |
|      29 | Apache                    | apache                                                                   |          0 |
|      30 | vim                       | vim                                                                      |          0 |
|      31 | vi                        | vi                                                                       |          0 |
|      32 | Teraterm                  | teraterm                                                                 |          0 |
|      33 | ESXi                      | esxi                                                                     |          0 |
|      34 | Ubuntu                    | ubuntu                                                                   |          0 |
|      35 | Vyos                      | vyos                                                                     |          0 |
|      36 | WinShot                   | winshot                                                                  |          0 |
|      37 | Skype for Business Server | skype-for-business-server                                                |          0 |
|      38 | GPD Pocket                | gpd-pocket                                                               |          0 |
|      39 | プリンタ                  | %e3%83%97%e3%83%aa%e3%83%b3%e3%82%bf                                     |          0 |
|      40 | SQL                       | sql                                                                      |          0 |
+---------+---------------------------+--------------------------------------------------------------------------+------------+
40 rows in set (0.00 sec)

<スポンサーリンク>

コメントを残す

Allowed tags:  you may use these HTML tags and attributes: <a href="">, <strong>, <em>, <h1>, <h2>, <h3>
Please note:  all comments go through moderation.

*

日本語が含まれない投稿は無視されますのでご注意ください。(スパム対策)