Прошу помочь разобраться как восстановить базу данных если от предыдущего сервера только папка
c таблицами баз данных. Самого mysql дампа нет. Если я копирую эту папку Nodeny на новый сервер в /var/db/mysql/nodeny то это ничего не дает. При запуске perl install -x я получаю ошибки
g /usr/local/nodeny/sat.cfg
<<< Подключение всех модулей >>>
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.019386 sec
SELECT * FROM config ORDER BY time DESC LIMIT 1
Строк: 0. Время выполнения sql: 0.0003 сек
--- Module MyNetwork ---
File patch.RU_user.pl
{ file=>'web/lang/RU_user.pl',hook=>'main' }
File patch.UA_user.pl
{ file=>'web/lang/UA_user.pl',hook=>'main' }
File patch.web_plugins
--- Module NoDeny ---
Tablespace is missing for table `nodeny`.`pon_onu`.
{
'sql' => 'CREATE TABLE IF NOT EXISTS `pon_onu` (
`id` mediumint(7) UNSIGNED NOT NULL AUTO_INCREMENT,
`sn` char(32) NOT NULL,
`vendor` char(64) NOT NULL DEFAULT \'\',
`model` char(24) NOT NULL DEFAULT \'\',
`firmware` char(24) NOT NULL DEFAULT \'\',
`descr` char(255) NOT NULL DEFAULT \'\',
`changed` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'ONU list\';
',
'param' => []
};
CREATE TABLE IF NOT EXISTS `pon_onu` (
`id` mediumint(7) UNSIGNED NOT NULL AUTO_INCREMENT,
`sn` char(32) NOT NULL,
`vendor` char(64) NOT NULL DEFAULT '',
`model` char(24) NOT NULL DEFAULT '',
`firmware` char(24) NOT NULL DEFAULT '',
`descr` char(255) NOT NULL DEFAULT '',
`changed` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `sn` (`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ONU list';
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000554 sec
Tablespace is missing for table `nodeny`.`data1`.
{
'param' => [],
'sql' => 'INSERT INTO data1 (uid) SELECT id FROM users ON DUPLICATE KEY UPDATE uid=uid;'
};
INSERT INTO data1 (uid) SELECT id FROM users ON DUPLICATE KEY UPDATE uid=uid;
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000341 sec
Tablespace is missing for table `nodeny`.`pon_ports`.
{
'sql' => 'CREATE TABLE IF NOT EXISTS `pon_ports` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`olt_id` smallint(11) NOT NULL,
`name` varchar(30) NOT NULL DEFAULT \'new olt\',
`p_index` varchar(30) NOT NULL,
`type` varchar(30) NOT NULL DEFAULT \'\',
`shelf` tinyint(2) NOT NULL DEFAULT \'0\',
`slot` tinyint(2) NOT NULL DEFAULT \'0\',
`port` tinyint(2) NOT NULL DEFAULT \'0\',
`tx` varchar(10) NOT NULL DEFAULT \'\',
`descr` varchar(250) NOT NULL DEFAULT \'\',
`status` tinyint(1) NOT NULL DEFAULT \'9\',
`enable` tinyint(1) NOT NULL DEFAULT \'0\',
`changed` int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
UNIQUE KEY `olt_id` (`olt_id`,`p_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'OLT ports\';
',
'param' => []
};
CREATE TABLE IF NOT EXISTS `pon_ports` (
`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`olt_id` smallint(11) NOT NULL,
`name` varchar(30) NOT NULL DEFAULT 'new olt',
`p_index` varchar(30) NOT NULL,
`type` varchar(30) NOT NULL DEFAULT '',
`shelf` tinyint(2) NOT NULL DEFAULT '0',
`slot` tinyint(2) NOT NULL DEFAULT '0',
`port` tinyint(2) NOT NULL DEFAULT '0',
`tx` varchar(10) NOT NULL DEFAULT '',
`descr` varchar(250) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '9',
`enable` tinyint(1) NOT NULL DEFAULT '0',
`changed` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `olt_id` (`olt_id`,`p_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OLT ports';
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000333 sec
Tablespace is missing for table `nodeny`.`services_log`.
{
'param' => [],
'sql' => 'CREATE TABLE IF NOT EXISTS `services_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(64) NOT NULL,
`uid` bigint(20) unsigned NOT NULL,
`token` bigint(20) unsigned NOT NULL,
`service_id` int(10) unsigned,
`tm_start` int(10) unsigned NOT NULL,
`tm_end` int(10) unsigned NOT NULL DEFAULT \'0\',
`price` float NOT NULL DEFAULT \'0\',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `module` (`module`(16)),
KEY `tm_start` (`tm_start`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
'
};
CREATE TABLE IF NOT EXISTS `services_log` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`module` varchar(64) NOT NULL,
`uid` bigint(20) unsigned NOT NULL,
`token` bigint(20) unsigned NOT NULL,
`service_id` int(10) unsigned,
`tm_start` int(10) unsigned NOT NULL,
`tm_end` int(10) unsigned NOT NULL DEFAULT '0',
`price` float NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `module` (`module`(16)),
KEY `tm_start` (`tm_start`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000342 sec
Tablespace is missing for table `nodeny`.`pon_bind`.
{
'sql' => 'CREATE TABLE IF NOT EXISTS pon_bind (
id smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
sn char(18) NOT NULL,
olt_id smallint(4) NOT NULL,
llid char(16) NOT NULL,
name char(32) NOT NULL DEFAULT \'\',
user int(10) NOT NULL DEFAULT \'0\',
place int(10) NOT NULL DEFAULT \'0\',
tx char(6) DEFAULT NULL,
rx char(6) DEFAULT NULL,
status char(30) DEFAULT NULL,
dereg char(24) DEFAULT NULL,
changed int(11) NOT NULL DEFAULT \'0\',
PRIMARY KEY (id),
UNIQUE KEY uniq (olt_id,llid) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=\'ONU binds\';
',
'param' => []
};
CREATE TABLE IF NOT EXISTS pon_bind (
id smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
sn char(18) NOT NULL,
olt_id smallint(4) NOT NULL,
llid char(16) NOT NULL,
name char(32) NOT NULL DEFAULT '',
user int(10) NOT NULL DEFAULT '0',
place int(10) NOT NULL DEFAULT '0',
tx char(6) DEFAULT NULL,
rx char(6) DEFAULT NULL,
status char(30) DEFAULT NULL,
dereg char(24) DEFAULT NULL,
changed int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (id),
UNIQUE KEY uniq (olt_id,llid) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='ONU binds';
Connecting to DBI:mysql:database=nodeny;host=localhost;port=3306;mysql_connect_timeout=5 : 0.000322 sec
Tablespace is missing for table `nodeny`.`notifications_users`.
sql error. Run with -v at /usr/local/nodeny/modules/NoDeny/run.pl line 86.
Да я еще пытался сделать mysql dump из папки nodeny c таблицами, но опять выдает ту же ошибку Tablespace is missing for table
Подскажите как же правильно перенести базу если осталась только папка с базой данных?