Mysqldump gives me errors
11/10/2018 11:47
We are in really bad shape because we just realized that the cron job that is suppose to be making a daily backup of our database hasn't been working for a long time. In fact, even when I'm logged in as root and try to run mysqldump from the command line, I get an error: [root@mother backup]# mysqldump -Qu root -pxxxx alb > /data/backup/alb.sql mysqldump: Got error: 1033: Incorrect information in file: './alb/charts.frm' when using LOCK TABLES What does this mean? Where can I get more info?

Source is Usenet: comp.databases.mysql
Sign in to add a comment

Answer score: 5
11/10/2018 11:47 - I'm still poking around, looking for answers.

Check this out, when I run mysqlcheck, it doesn't even seem to know of the existence of the table alb.charts. And it fails to fix it.

[root@mother backup]# mysqlcheck -Aac --auto-repair --password=xxxx alb.accounting OKalb.accounting_label_loot OKalb.accounting_loot OKalb.accounting_sub_refills OKalb.accounting_sub_transactions OKalb.accounting_subs OKalb.afb_accounts OKalb.afb_accounts_has_perms OKalb.afb_blacklist_dirs OKalb.afb_blacklist_ext OKalb.afb_blacklist_files OKalb.afb_log OKalb.afb_settings OKalb.afb_shares OKalb.affiliates OKalb.album_karma OKalb.album_suppression OKalb.albums OKalb.amg_ids OKalb.articles OKalb.artist_signup OKalb.artists OKalb.banned_ips OKalb.blackout_codes OKalb.booster_plans OKalb.bpm_promo_tracks OKalb.cancellations OKalb.categories OKalb.cdbaby_optins OKalb.code_level_plane OKalb.comment_karma OKalb.comment_text OKalb.comments OKalb.content OKalb.coupons OKalb.discussions OKalb.downloads OKalb.email_blasts OKalb.email_skins OKalb.encode_albums OKalb.encode_tracks OKalb.feature_groups OKalb.fortunes OKalb.ftp_uploads OKalb.ftp_uploads_files OKalb.ftp_users OKalb.genres OKalb.gift_cards OKalb.group_albums OKalb.group_blog OKalb.group_fans OKalb.group_journals OKalb.group_managers OKalb.group_news OKalb.group_photo_albums OKalb.group_photos OKalb.group_podcasts OKalb.group_shows OKalb.group_tracks OKalb.groups OKalb.hottopic_match OKalb.hottopic_match_al OKalb.hottopic_nomatch OKalb.hottopic_nomatch_al OKalb.ingrooves_codes OKalb.ioda_opted_out OKalb.label_aliases OKalb.label_history OKalb.label_upload_album OKalb.labels OKalb.lunch_cards OKalb.markets OKalb.merchandise OKalb.owners OKalb.owners_users_xref OKalb.phpbb_auth_access OKalb.phpbb_banlist OKalb.phpbb_categories OKalb.phpbb_config OKalb.phpbb_confirm OKalb.phpbb_disallow OKalb.phpbb_forum_prune OKalb.phpbb_forums OKalb.phpbb_groups OKalb.phpbb_posts OKalb.phpbb_posts_text OKalb.phpbb_privmsgs OKalb.phpbb_privmsgs_text OKalb.phpbb_ranks OKalb.phpbb_search_results OKalb.phpbb_search_wordmatch OKalb.phpbb_sessions OKalb.phpbb_smilies OKalb.phpbb_themes OKalb.phpbb_themes_name OKalb.phpbb_topics OKalb.phpbb_topics_watch OKalb.phpbb_user_group OKalb.phpbb_users OKalb.phpbb_vote_desc OKalb.phpbb_vote_results OKalb.phpbb_vote_voters OKalb.phpbb_words OKalb.playlist_tracks OKalb.playlists OKalb.poll_answers OKalb.poll_questions OKalb.promotions OKalb.queries OKalb.reviews OKalb.servers OKalb.store_label_xref OKalb.stores OKalb.stories OKalb.story_submissions OKalb.sub_plans OKalb.sub_refills OKalb.sub_transactions OKalb.tasks OKalb.tracks OKalb.tracks_test OKalb.transactions OKalb.upload_folders OKalb.user_acl OKalb.user_cart_general OKalb.user_info OKalb.user_info_xref OKalb.user_karma OKalb.user_subscription_transaction OKalb.users OKalb.variables OKalb.zipcodes OKbluepie.servers OKbluepie.ticket OKgreg.category OKgreg.home_depot_products OKgreg.job_managers OKgreg.jobs OKgreg.product_links OKgreg.product_vectors OKgreg.store OKgreg.test_products OKmysql.columns_priv OKmysql.db OKmysql.func OKmysql.help_category OKmysql.help_keyword OKmysql.help_relation OKmysql.help_topic OKmysql.host OKmysql.proc OKmysql.procs_priv OKmysql.tables_priv OKmysql.time_zone OKmysql.time_zone_leap_second OKmysql.time_zone_name OKmysql.time_zone_transition OKmysql.time_zone_transition_type OKmysql.user OKwidgets.collections OKwidgets.images OKwidgets.poll_responses OKwidgets.polls OKwidgets.sessions OKwidgets.tracks OKwidgets.users OK

Source is Usenet: comp.databases.mysql
Sign in to add a comment

Answer score: 5
11/10/2018 11:47 - This is interesting. I'm poking around, looking for answers. I log into the database as root and check out the mysql database itself. I look in the tables table, that has info on all tables. The table chart stands out in this list as the only table that doesn't know what its engine is: mysql> select TABLE_NAME, ENGINE, TABLE_TYPE from tables;+---------------------------------------+--------+-------------+| TABLE_NAME | ENGINE | TABLE_TYPE |+---------------------------------------+--------+-------------+| CHARACTER_SETS | MEMORY | SYSTEM VIEW || COLLATIONS | MEMORY | SYSTEM VIEW || COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY | SYSTEM VIEW || COLUMNS | MyISAM | SYSTEM VIEW || COLUMN_PRIVILEGES | MEMORY | SYSTEM VIEW || KEY_COLUMN_USAGE | MEMORY | SYSTEM VIEW || PROFILING | MEMORY | SYSTEM VIEW || ROUTINES | MyISAM | SYSTEM VIEW || SCHEMATA | MEMORY | SYSTEM VIEW || SCHEMA_PRIVILEGES | MEMORY | SYSTEM VIEW || STATISTICS | MEMORY | SYSTEM VIEW || TABLES | MEMORY | SYSTEM VIEW || TABLE_CONSTRAINTS | MEMORY | SYSTEM VIEW || TABLE_PRIVILEGES | MEMORY | SYSTEM VIEW || TRIGGERS | MyISAM | SYSTEM VIEW || USER_PRIVILEGES | MEMORY | SYSTEM VIEW || VIEWS | MyISAM | SYSTEM VIEW || accounting | MyISAM | BASE TABLE || accounting_label_loot | MyISAM | BASE TABLE || accounting_loot | MyISAM | BASE TABLE || accounting_sub_refills | MyISAM | BASE TABLE || accounting_sub_transactions | MyISAM | BASE TABLE || accounting_subs | MyISAM | BASE TABLE || afb_accounts | MyISAM | BASE TABLE || afb_accounts_has_perms | MyISAM | BASE TABLE || afb_blacklist_dirs | MyISAM | BASE TABLE || afb_blacklist_ext | MyISAM | BASE TABLE || afb_blacklist_files | MyISAM | BASE TABLE || afb_log | MyISAM | BASE TABLE || afb_settings | MyISAM | BASE TABLE || afb_shares | MyISAM | BASE TABLE || affiliates | MyISAM | BASE TABLE || album_karma | MyISAM | BASE TABLE || album_suppression | MyISAM | BASE TABLE || albums | MyISAM | BASE TABLE || amg_ids | MyISAM | BASE TABLE || articles | MyISAM | BASE TABLE || artist_signup | MyISAM | BASE TABLE || artists | MyISAM | BASE TABLE || banned_ips | MyISAM | BASE TABLE || blackout_codes | MyISAM | BASE TABLE || booster_plans | MyISAM | BASE TABLE || bpm_promo_tracks | MyISAM | BASE TABLE || cancellations | MyISAM | BASE TABLE || categories | MyISAM | BASE TABLE || cdbaby_optins | MyISAM | BASE TABLE || charts | NULL | BASE TABLE || code_level_plane | MyISAM | BASE TABLE || comment_karma | MyISAM | BASE TABLE || comment_text | MyISAM | BASE TABLE || comments | MyISAM | BASE TABLE || content | MyISAM | BASE TABLE || coupons | MyISAM | BASE TABLE || discussions | MyISAM | BASE TABLE || downloads | MyISAM | BASE TABLE || email_blasts | MyISAM | BASE TABLE || email_skins | MyISAM | BASE TABLE || encode_albums | MyISAM | BASE TABLE || encode_tracks | MyISAM | BASE TABLE || feature_groups | MyISAM | BASE TABLE || fortunes | MyISAM | BASE TABLE || ftp_uploads | InnoDB | BASE TABLE || ftp_uploads_files | InnoDB | BASE TABLE || ftp_users | MyISAM | BASE TABLE || genres | MyISAM | BASE TABLE || gift_cards | MyISAM | BASE TABLE || group_albums | MyISAM | BASE TABLE || group_blog | MyISAM | BASE TABLE || group_fans | MyISAM | BASE TABLE || group_journals | MyISAM | BASE TABLE || group_managers | MyISAM | BASE TABLE || group_news | MyISAM | BASE TABLE || group_photo_albums | MyISAM | BASE TABLE || group_photos | MyISAM | BASE TABLE || group_podcasts | MyISAM | BASE TABLE || group_shows | MyISAM | BASE TABLE || group_tracks | MyISAM | BASE TABLE || groups | MyISAM | BASE TABLE || hottopic_match | MyISAM | BASE TABLE || hottopic_match_al | MyISAM | BASE TABLE || hottopic_nomatch | MyISAM | BASE TABLE || hottopic_nomatch_al | MyISAM | BASE TABLE || ingrooves_codes | MyISAM | BASE TABLE || ioda_opted_out | MyISAM | BASE TABLE || label_aliases | MyISAM | BASE TABLE || label_history | MyISAM | BASE TABLE || label_upload_album | MyISAM | BASE TABLE || labels | MyISAM | BASE TABLE || labels_parents_view | NULL | VIEW || lunch_cards | MyISAM | BASE TABLE || markets | MyISAM | BASE TABLE || merchandise | MyISAM | BASE TABLE || owners | MyISAM | BASE TABLE || owners_users_xref | MyISAM | BASE TABLE || phpbb_auth_access | MyISAM | BASE TABLE || phpbb_banlist | MyISAM | BASE TABLE || phpbb_categories | MyISAM | BASE TABLE || phpbb_config | MyISAM | BASE TABLE || phpbb_confirm | MyISAM | BASE TABLE || phpbb_disallow | MyISAM | BASE TABLE || phpbb_forum_prune | MyISAM | BASE TABLE || phpbb_forums | MyISAM | BASE TABLE || phpbb_groups | MyISAM | BASE TABLE || phpbb_posts | MyISAM | BASE TABLE || phpbb_posts_text | MyISAM | BASE TABLE || phpbb_privmsgs | MyISAM | BASE TABLE || phpbb_privmsgs_text | MyISAM | BASE TABLE || phpbb_ranks | MyISAM | BASE TABLE || phpbb_search_results | MyISAM | BASE TABLE || phpbb_search_wordmatch | MyISAM | BASE TABLE || phpbb_sessions | MyISAM | BASE TABLE || phpbb_smilies | MyISAM | BASE TABLE || phpbb_themes | MyISAM | BASE TABLE || phpbb_themes_name | MyISAM | BASE TABLE || phpbb_topics | MyISAM | BASE TABLE || phpbb_topics_watch | MyISAM | BASE TABLE || phpbb_user_group | MyISAM | BASE TABLE || phpbb_users | MyISAM | BASE TABLE || phpbb_vote_desc | MyISAM | BASE TABLE || phpbb_vote_results | MyISAM | BASE TABLE || phpbb_vote_voters | MyISAM | BASE TABLE || phpbb_words | MyISAM | BASE TABLE || playlist_tracks | MyISAM | BASE TABLE || playlists | MyISAM | BASE TABLE || poll_answers | MyISAM | BASE TABLE || poll_questions | MyISAM | BASE TABLE || promotions | MyISAM | BASE TABLE || queries | MyISAM | BASE TABLE || reviews | MyISAM | BASE TABLE || servers | MyISAM | BASE TABLE || store_label_xref | MyISAM | BASE TABLE || stores | MyISAM | BASE TABLE || stories | MyISAM | BASE TABLE || story_submissions | MyISAM | BASE TABLE || sub_plans | MyISAM | BASE TABLE || sub_refills | MyISAM | BASE TABLE || sub_transactions | MyISAM | BASE TABLE || tasks | MyISAM | BASE TABLE || tracks | MyISAM | BASE TABLE || tracks_test | MyISAM | BASE TABLE || transactions | MyISAM | BASE TABLE || upload_folders | MyISAM | BASE TABLE || user_acl | MyISAM | BASE TABLE || user_cart_general | MyISAM | BASE TABLE || user_info | MyISAM | BASE TABLE || user_info_xref | MyISAM | BASE TABLE || user_karma | MyISAM | BASE TABLE || user_subscription_transaction | MyISAM | BASE TABLE || users | MyISAM | BASE TABLE || variables | MyISAM | BASE TABLE || zipcodes | MyISAM | BASE TABLE || servers | MyISAM | BASE TABLE || ticket | MyISAM | BASE TABLE || category | MyISAM | BASE TABLE || home_depot_products | MyISAM | BASE TABLE || job_managers | MyISAM | BASE TABLE || jobs | MyISAM | BASE TABLE || product_links | MyISAM | BASE TABLE || product_vectors | MyISAM | BASE TABLE || store | MyISAM | BASE TABLE || test_products | MyISAM | BASE TABLE || columns_priv | MyISAM | BASE TABLE || db | MyISAM | BASE TABLE || func | MyISAM | BASE TABLE || help_category | MyISAM | BASE TABLE || help_keyword | MyISAM | BASE TABLE || help_relation | MyISAM | BASE TABLE || help_topic | MyISAM | BASE TABLE || host | MyISAM | BASE TABLE || proc | MyISAM | BASE TABLE || procs_priv | MyISAM | BASE TABLE || tables_priv | MyISAM | BASE TABLE || time_zone | MyISAM | BASE TABLE || time_zone_leap_second | MyISAM | BASE TABLE || time_zone_name | MyISAM | BASE TABLE || time_zone_transition | MyISAM | BASE TABLE || time_zone_transition_type | MyISAM | BASE TABLE || user | MyISAM | BASE TABLE || collections | MyISAM | BASE TABLE || images | MyISAM | BASE TABLE || poll_responses | MyISAM | BASE TABLE || polls | MyISAM | BASE TABLE || sessions | MyISAM | BASE TABLE || tracks | MyISAM | BASE TABLE || users | MyISAM | BASE TABLE |+---------------------------------------+--------+-------------+

Source is Usenet: comp.databases.mysql
Sign in to add a comment

eDiscover
Helpforce eDiscover provides technical articles updated each dayHelpforce eDiscover RSS feed contains the latest technical articles in RSS
Click the logo to go back to the main page
Search eDiscover
  
Categories

Click an icon to go to that category

Helpforce eDiscover contains articles about Microsoft Windows Helpforce eDiscover contains articles about Apple products and MacOS Helpforce eDiscover contains articles about Linux and POSIX operating systems Helpforce eDiscover contains articles about Helpforce Helpforce has a large variety of technical information and articles for you to read Helpforce eDiscover contains articles about databases, MYSQL, SQL Server Oracle Helpforce eDiscover contains articles about Java, JVM and the JRE Helpforce eDiscover contains articles about the QNX operating system Helpforce eDiscover contains articles about Oracle Solaris and Open Solaris Helpforce eDiscover contains articles about RISC OS, Acorn and the BBC Micro Helpforce eDiscover contains articles about Amiga and AmigaOS

Type your comment into the box below