PowerDNS database table records

Source: Internet
Author: User
Tags mysql show databases domain server
Welcome to the Linux community forum, interact with 2 million technical staff to enter the Database connection method [root @ gd02-qa-plxt2-nodomain] # mysql-uvipdns-pvipdns-h10.0.3.99mysqlshowdatabases; + -------------------- + | Database | + -------------------- + | information_sche

Welcome to the Linux community forum, interact with 2 million technical staff> enter the database connection method [root @ gd02-qa-plxt2-nodomain/] # mysql-u vipdns-pvipdns-h 10.0.3.99 mysql show databases; + -------------------- + | Database | + -------------------- + | information_sche

Welcome to the Linux community forum and interact with 2 million technicians>

Database Connection Method

[Root @ gd02-qa-plxt2-nodomain/] # mysql-u vipdns-pvipdns-h 10.0.3.99

Mysql> show databases;

+ -------------------- +

| Database |

+ -------------------- +

| Information_schema |

| Pdns |

+ -------------------- +

2 rows in set (0.00 sec)

Note:

-U specified user name (vipdns)

-P password (vipdns)

-H specifies the host (10.0.3.99)

Default port 3306

Table Information

Mysql> show tables;

+ -------------------- +

| Tables_in_pdns |

+ -------------------- +

| Cryptokeys |

| Domainmetadata |

| Domains |

| Perm_items |

| Perm_templ |

| Perm_templ_items |

| Records |

| Supermasters |

| Tsigkeys |

| Users |

| Zone_templ |

| Zone_templ_records |

| Zones |

+ -------------------- +

13 rows in set (0.00 sec)

Important: domain table records table

Domain table structure

Mysql> desc domains;

+ ----------------- + -------------- + ------ + ----- + --------- + ---------------- +

| Field | Type | Null | Key | Default | Extra |

+ ----------------- + -------------- + ------ + ----- + --------- + ---------------- +

| Id | int (11) | NO | PRI | NULL | auto_increment |

| Name | varchar (255) | NO | UNI | NULL |

| Master | varchar (128) | YES | NULL |

| Last_check | int (11) | YES | NULL |

| Type | varchar (6) | NO | NULL |

| Notified_serial | int (11) | YES | NULL |

| Account | varchar (40) | YES | NULL |

+ ----------------- + -------------- + ------ + ----- + --------- + ---------------- +

7 rows in set (0.01 sec)

Data in the current domains table

Mysql> select * from domains;

+ ---- + --------------------- + -------- + ------------ + -------- + ----------------- + --------- +

| Id | name | master | last_check | type | notified_serial | account |

+ ---- + --------------------- + -------- + ------------ + -------- + ----------------- + --------- +

| 1 | vclound.com | NULL | MASTER | NULL |

| 2 | 3.0.10.in-addr. arpa | NULL | MASTER | NULL |

+ ---- + --------------------- + -------- + ------------ + -------- + ----------------- + --------- +

2 rows in set (0.00 sec)

Note:

Id-primary key

Name-domain name (two already added), First follow vclound.com

Master-Unknown

Last_check-Unknown

Type-whether the Primary Domain Server (usually only one DNS is MASTER)

Notified_serial-Modify version information

Account-Unknown

Add a 163.com domain name and call an SQL example

Insert into pdns. domains (name, type) values ('2017. com', 'master ');

[1] [2] [3]

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.