MySQL in DNSmanager

From ISPWiki
Jump to: navigation, search

Starting from version 5.30 MySQL can be used as a database for DNSmanager

We use Sqlite by default, as this database management system is a perfect solution for managing small amounts of data typical for DNSmanager. However, if you have a large number of domains and concurrent queries, we recommend using MySQL:

create a database in MySQL

create database dnsmgr default character set utf8;

add the following string into the /usr/local/mgr5/etc/dnsmgr.conf file

DBType mysql

You can connect to the database with following parameters:

  • DBHost - MySQL database server. The default value - localhost
  • DBUser - databse username. The default value - root
  • DBPassword - password of the database user
  • DBName - database name. The default value - dnsmgr

Restart the panel. DNSmanager will start with the clean database.

You can import data from sqlite into mysql, if needed. Make the database dump into the file:

sqlite3 /usr/local/mgr5/etc/dnsmgr.db .dump > /root/dnsmgr.db.sqlite

Upload the dump into mysql:

mysql -uroot -p dnsmgr < /root/dnsmgr.db.mysql