Skip to content

Instantly share code, notes, and snippets.

@cnic023

cnic023/checkdb

Last active September 29, 2020 22:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save cnic023/74fcfb52db8cd37009befe71e8f7cb05 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save cnic023/74fcfb52db8cd37009befe71e8f7cb05 to your computer and use it in GitHub Desktop.
Download ZIP
Incorrect key file for table in Ampache SQL DB
Raw
checkdb
ampachedb.access_list OK
ampachedb.album OK
ampachedb.artist OK
ampachedb.bookmark OK
ampachedb.broadcast OK
ampachedb.cache_object_count
Error : Incorrect key file for table 'cache_object_count'; try to repair it
error : Corrupt
ampachedb.cache_object_count_run
Error : Incorrect key file for table 'cache_object_count_run'; try to repair it
error : Corrupt
ampachedb.catalog OK
ampachedb.catalog_local OK
ampachedb.catalog_remote OK
ampachedb.channel OK
ampachedb.clip OK
ampachedb.daap_session OK
ampachedb.democratic OK
ampachedb.image OK
ampachedb.ip_history OK
ampachedb.label OK
ampachedb.label_asso OK
ampachedb.license OK
ampachedb.live_stream OK
ampachedb.localplay_httpq OK
ampachedb.localplay_mpd OK
ampachedb.metadata OK
ampachedb.metadata_field OK
ampachedb.movie OK
ampachedb.now_playing OK
ampachedb.object_count
Error : Incorrect key file for table 'object_count'; try to repair it
error : Corrupt
ampachedb.personal_video OK
ampachedb.player_control OK
ampachedb.playlist
Error : Incorrect key file for table 'playlist'; try to repair it
error : Corrupt
ampachedb.playlist_data OK
ampachedb.podcast OK
ampachedb.podcast_episode OK
ampachedb.preference OK
ampachedb.rating
Error : Incorrect key file for table 'rating'; try to repair it
error : Corrupt
ampachedb.recommendation OK
ampachedb.recommendation_item OK
ampachedb.search OK
ampachedb.session OK
ampachedb.session_remember OK
ampachedb.session_stream OK
ampachedb.share OK
ampachedb.song OK
ampachedb.song_data OK
ampachedb.song_preview OK
ampachedb.stream_playlist OK
ampachedb.tag OK
ampachedb.tag_map OK
ampachedb.tag_merge OK
ampachedb.tmp_browse OK
ampachedb.tmp_playlist OK
ampachedb.tmp_playlist_data OK
ampachedb.tvshow OK
ampachedb.tvshow_episode OK
ampachedb.tvshow_season OK
ampachedb.update_info OK
ampachedb.user OK
ampachedb.user_activity OK
ampachedb.user_catalog OK
ampachedb.user_flag OK
ampachedb.user_follower OK
ampachedb.user_preference OK
ampachedb.user_pvmsg OK
ampachedb.user_shout OK
ampachedb.user_vote OK
ampachedb.video OK
ampachedb.wanted OK
Raw
disk_usage
Filesystem Size Used Avail Use% Mounted on
udev 1.9G 0 1.9G 0% /dev
tmpfs 383M 1.5M 381M 1% /run
/dev/mapper/ubuntu--vg-ubuntu--lv 196G 12G 175G 7% /
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/loop0 72M 72M 0 100% /snap/lxd/16099
/dev/sda2 976M 197M 713M 22% /boot
/dev/loop1 55M 55M 0 100% /snap/core18/1880
/dev/loop2 71M 71M 0 100% /snap/lxd/16922
/dev/loop5 31M 31M 0 100% /snap/snapd/9279
/dev/loop3 30M 30M 0 100% /snap/snapd/8542
/dev/loop4 56M 56M 0 100% /snap/core18/1885
tmpfs 383M 0 383M 0% /run/user/1000
/dev/sdb1 1.9T 135G 1.7T 8% /archive
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment