[mythtv-users] regenerate newssites table in mysql

Josu Lazkano josu.lazkano at gmail.com
Tue Apr 21 12:22:30 UTC 2015


Hello,

I was playing with newssites mysql table (making a restore from
backup), and I delete the entire table.

This is the lines that I execute:

DROP TABLE IF EXISTS `newssites`;
CREATE TABLE `newssites` (
LOCK TABLES `newssites` WRITE;
INSERT INTO `newssites` (`name`, `category`, `url`, `ico`, `updated`,
`podcast`) VALUES ('...

How could I generate again the table?

I want to import and old data from a backup file.

Thanks for your help.

Best regards.


-- 
Josu Lazkano


More information about the mythtv-users mailing list