Home » Forums » MythDora » Updating

Tranfer database problems

  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:c9e1cb9316a878442e4a41144b2ce273' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>I moved to new hardware, installed Mythdora 5.0 (previously had 4.0 i think) but cannot get my database to transfer.</p>\n<p>I followed the instructions here: <a href=\"http://www.mythdora.com/?q=user/reset/480/1216409178/6f1f75d489e97b0f213ff0454b08c50f\">http://www.mythdora.com/?q=user/reset/480/1216409178/6f1f75d489e97b0f213ff0454b08c50f</a></p>\n<p>but when restoring the data into mythconverg, it says \"ERROR 1136 (21501) at line 1: column count doesn\'t match value count at row 1\"</p>\n<p>I also tried the mythdora db backup tools (make a backup on thr old system and tried to restore it on thr new one), but I get errors, and then I can\'t connect to the backend, and can\'t get into myth-tv setup either.</p>\n<p>Any ideas how I can get this to work? I really don\'t want to lose my database.</p>\n', created = 1368998503, expire = 1369084903, headers = '', serialized = 0 WHERE cid = '1:c9e1cb9316a878442e4a41144b2ce273' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:f1dba011d0e116208124fa85820a38d2' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p><a href=\"http://www.gossamer-threads.com/lists/engine?list=mythtv&amp;do=search_results&amp;search_forum=forum_1&amp;search_string=ERROR+1136&amp;search_type=AND\">http://www.gossamer-threads.com/lists/engine?list=mythtv&amp;do=search_results&amp;search_forum=forum_1&amp;search_string=ERROR+1136&amp;search_type=AND</a></p>\n<p>\"Please ignore the man behind the curtain\"<br />\nDennis</p>\n', created = 1368998503, expire = 1369084903, headers = '', serialized = 0 WHERE cid = '1:f1dba011d0e116208124fa85820a38d2' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:7ee834acd95a5efc693cacccaa73a62b' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>\"Please ignore the man behind the curtain\"<br />\nDennis</p>\n', created = 1368998503, expire = 1369084903, headers = '', serialized = 0 WHERE cid = '1:7ee834acd95a5efc693cacccaa73a62b' in /var/www/mythdora/html/includes/cache.inc on line 109.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: SELECT data, created, headers, expire, serialized FROM cache_filter WHERE cid = '1:d6ea2fc428659994f9156405fe253bfa' in /var/www/mythdora/html/includes/cache.inc on line 26.
  • user warning: Table './drupal_gding/cache_filter' is marked as crashed and should be repaired query: UPDATE cache_filter SET data = '<p>ok, got it thanks.</p>\n<p>for others, make sure you use the -c option for dumping your database.</p>\n<p>I had to create a dummy database on my new system, import the backup to the dummy database, then re-dump it with the -c option, clean up the extracted tables (as per mythtv wiki), then i was able to re-import then to the new database.</p>\n', created = 1368998503, expire = 1369084903, headers = '', serialized = 0 WHERE cid = '1:d6ea2fc428659994f9156405fe253bfa' in /var/www/mythdora/html/includes/cache.inc on line 109.
Submitted by fakeplastic on July 18, 2008 - 12:38pm

I moved to new hardware, installed Mythdora 5.0 (previously had 4.0 i think) but cannot get my database to transfer.

I followed the instructions here: http://www.mythdora.com/?q=user/reset/480/1216409178/6f1f75d489e97b0f213ff0454b08c50f

but when restoring the data into mythconverg, it says "ERROR 1136 (21501) at line 1: column count doesn't match value count at row 1"

I also tried the mythdora db backup tools (make a backup on thr old system and tried to restore it on thr new one), but I get errors, and then I can't connect to the backend, and can't get into myth-tv setup either.

Any ideas how I can get this to work? I really don't want to lose my database.

‹ Yum Upgrade Issue mythdora rpm problem ›

http://www.gossamer-threads.c

Submitted by d00dtv on July 18, 2008 - 1:32pm.

http://www.gossamer-threads.com/lists/engine?list=mythtv&do=search_results&search_forum=forum_1&search_string=ERROR+1136&search_type=AND

"Please ignore the man behind the curtain"
Dennis

—

"Please ignore the man behind the curtain"
Dennis

»

ok, got it thanks. for

Submitted by fakeplastic on July 22, 2008 - 4:59pm.

ok, got it thanks.

for others, make sure you use the -c option for dumping your database.

I had to create a dummy database on my new system, import the backup to the dummy database, then re-dump it with the -c option, clean up the extracted tables (as per mythtv wiki), then i was able to re-import then to the new database.

»