2.3 Creating the tables

Next, create the tables in your database that will hold the DNS data.

Running mydns --create-tables will cause MyDNS to output CREATE TABLE statements appropriate for your database.

MySQL:

$ mydns --create-tables | mysql -h host -u username -p mydns

PostgreSQL:

$ mydns --create-tables | psql mydns

After you have created the tables, you should have two tables in your `mydns' database, called `soa' (see section 3.1 The `soa' table) and `rr' (see section 3.2 The `rr' table).