# TMobile DB introduction

## **Log File Upload**

### How to upload log files

- ##### Upload by web
    
    
    - [http://173.249.196.168/log\_upload/](http://173.249.196.168/log_upload/)  
        [![image.png](https://doc.netimizer.com/uploads/images/gallery/2025-04/scaled-1680-/hrEimage.png)](https://doc.netimizer.com/uploads/images/gallery/2025-04/hrEimage.png)
    - Drag ZIP file or DML file and click "Upload" button.   
        [![image.png](https://doc.netimizer.com/uploads/images/gallery/2025-04/scaled-1680-/hc6image.png)](https://doc.netimizer.com/uploads/images/gallery/2025-04/hc6image.png)
    - When log upload completes, it'll show "done".
- ##### Upload ZIP file <span style="color: rgb(68, 68, 68);">by FTP</span>

- - FTP server: 173.249.196.168  
        user ID: log\_upload  
        password: wm\_log\_upload
    - You can't upload DML file without compression
    - You should ZIP log files and upload ZIP file
    - When ZIP file upload is complete, server will move ZIP file to other folder, and unzip, and process log files

## **Database Explanation**

### How to access DB

- ##### MySQL DB
    
    
    - IP: 173.249.196.168  
        username: tmo\_db  
        password: wm\_tmo\_db

### How to monitor uploaded log files

- ##### Monitor uploaded log files by web
    
    
    - [http://173.249.196.168/log\_list/](http://173.249.196.168/log_list/)

[![image.png](https://doc.netimizer.com/uploads/images/gallery/2025-04/scaled-1680-/xlwimage.png)](https://doc.netimizer.com/uploads/images/gallery/2025-04/xlwimage.png)

### How to view DB

##### DB Table explanation

- tb\_wm\_\_1\_log\_info  
    [![image.png](https://doc.netimizer.com/uploads/images/gallery/2025-04/scaled-1680-/6xwimage.png)](https://doc.netimizer.com/uploads/images/gallery/2025-04/6xwimage.png)
    - - 'logfile\_id' column - ID of log file
        - 'logfile\_name' column - log file name (\*.DML)
        - 'logfile\_size' column - log file size in bytes
        - 'uploader\_name' column - uploader
        - 'uploader\_email' column
        - 'upload\_datetime' column - uploaded time
        - 'm\_starttime' column - measurement start time
        - 'm\_endtime' column - measurement end time
- tb\_wm\_\_2\_data\_field\_info  
    [![image.png](https://doc.netimizer.com/uploads/images/gallery/2025-04/scaled-1680-/M71image.png)](https://doc.netimizer.com/uploads/images/gallery/2025-04/M71image.png)
    
    
    - dma\_field\_name - internal ID (for server developer)
    - dma\_group\_name - group and name of KPI (that user will see in LMA)
    - table\_name - table name in this DB
    - field\_name - field name in table
    - field\_type - field type in table
    - 
    - <span style="color: rgb(186, 55, 42);">If you change favorite file to includes more KPIs, new KPIs will be added as new record in this 'tb\_wm\_\_2\_data\_field\_info' table.</span>
- Other tables 
    - tb\_wm\_ce\_... - Events
    - tb\_wm\_cr\_... - Call Results
    - tb\_wm\_sv\_... - Sampled Values
- table naming 
    - general - General
    - nr5g - NR 5G
    - lte - LTE
    - ltea - LTE-A