Differences

This shows you the differences between two versions of the page.

--- powerdns_centos7 [2015/06/24 20:20] – herwarth
+++ powerdns_centos7 [2015/06/24 20:34] (current) – herwarth
@@ Line 100: / Line 100: @@
 =====Backup and restore=====
-On the old server:
+On the old server with older PowerDNS database:
-  mysqldump -u powerdns -p powerdns --skip-add-drop-table domains records supermasters zones > /var/tmp/backup_tables.sql
+  mysqldump -u powerdns -p powerdns > /var/tmp/backup_tables.sql
 On the new server:
   mysql -u powerdns -p powerdns < /var/tmp/backup_tables.sql
+Upgrade to new schema:
+  mysql -u powerdns -p powerdns < /usr/share/doc/pdns-backend-mysql-3.4.4/nodnssec-3.x_to_3.4.0_schema.mysql.sql
 {{tag>centos}}