Possible to restore a deleted table from mptvdb? (1 Viewer)

[Holzi]

Hello!
I 'accidently' deleted a table from mptvdb (MySQL). Is it possible to restore it (without content) or does there only help a complete reinstall of MediaPortal and/or MySQL?

Thanks!

 

[mm1352000]

Ooops!

Yeah, it is possible to restore without content. If you tell me the table name, I can supply the SQL to run to recreate it.

 

[Holzi]

If you tell me the table name, I can supply the SQL to run to recreate it.

Table name is: mptvdb.program

 

[mm1352000]

Here's the SQL:

CREATE TABLE `program` (
`idProgram` int(11) NOT NULL AUTO_INCREMENT,
`idChannel` int(11) NOT NULL,
`startTime` datetime NOT NULL,
`endTime` datetime NOT NULL,
`title` varchar(2000) NOT NULL,
`description` text NOT NULL,
`seriesNum` varchar(200) NOT NULL,
`episodeNum` varchar(200) NOT NULL,
`genre` varchar(200) NOT NULL,
`originalAirDate` datetime NOT NULL,
`classification` varchar(200) NOT NULL,
`starRating` int(11) NOT NULL,
`parentalRating` int(11) NOT NULL,
`episodeName` text NOT NULL,
`episodePart` text NOT NULL,
`state` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`idProgram`),
UNIQUE KEY `idProgramBeginEnd` (`idChannel`,`startTime`,`endTime`),
KEY `IDX_Program_State` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC$$

 

[Holzi]

Here's the SQL:

Tried that with the workbench and command line but both times there seems to be a syntax error. I am on MySQL 5.6. Thanks!

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DYNAMIC$$' at line 21

 

[mm1352000]

Sorry for the delayed response - cooking.

Try removing the "row_format..." part. It isn't important.

 

[Holzi]

Sorry for the delayed response

No problem.
The program.ibd gets created (even with the row_format part) but it is missing the .frm file. And I cant see the table in the MySQL workbench. I think I will give up for today.