Uploading the database schema. To create the MySQL DB for Bind’s usage, simply create and database and use the file to create the tables and stored procedures.
Example.
[jiajun@sm-geodnssoc ~]$ mysql –u user –p
mysql> CREATE DATABASE `geo-mozilla-com`;
mysql> exit
[jiajun@sm-geodnssoc ~]$ mysql -u user -p geo-mozilla-com< database.sql
rebuild the views either from geodns.pl/web UI/mysql before restarting the DNS server
[jiajun@sm-geodnssoc ~]$ mysql –u user –p
mysql> call buildViews();
NOTE: I had reuploaded the schema file on 5 Aug 2337 hrs (GMT +8).
Changes:
- the new version does not drop the table if it exists. It will create the table only if it does not exists. However, stored procedures will always be recreated.
Files: