Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#70 Couldn't execute 'show create table `killchart`'

v3.0_testing
open
nobody
5
2015-02-05
2012-09-17
Anonymous
No

bash -x /usr/local/bin/automysqlbackup
+ shopt -s extglob
+ let filename_flag_encrypted=0x01
+ let filename_flag_gz=0x02
+ let filename_flag_bz2=0x04
+ let filename_flag_diff=0x08
+ let E=0x00
+ let N=0x00
+ let E_dbdump_failed=0x01
+ let E_backup_local_failed=0x02
+ let E_mkdir_basedir_failed=0x04
+ let E_mkdir_subdirs_failed=0x08
+ let E_perm_basedir=0x10
+ let E_enc_cleartext_delfailed=0x20
+ let E_enc_failed=0x40
+ let E_db_empty=0x80
+ let E_create_pipe_failed=0x100
+ let E_missing_deps=0x200
+ let E_no_basedir=0x400
+ let E_config_backupdir_not_writable=0x800
+ let E_dump_status_failed=0x1000
+ let E_dump_fullschema_failed=0x2000
+ let N_config_file_missing=0x01
+ let N_arg_conffile_parsed=0x02
+ let N_arg_conffile_unreadable=0x04
+ let N_too_many_args=0x08
+ let N_latest_cleanup_failed=0x10
+ let N_backup_local_nofiles=0x20
+ export -f remove_datetimeinfo
+ NO_ARGS=0
+ E_OPTERROR=85
+ (( 0 == 0 ))
+ echo 'Invoking backup method.'
+ echo
+ method_backup
+ manifest_entries_corrupted=()
+ manifest_entries_user_action_required=()
+ load_default_config
+ CONFIG_configfile=/etc/automysqlbackup/automysqlbackup.conf
+ CONFIG_backup_dir=/var/backup/db
+ CONFIG_multicore=yes
+ CONFIG_multicore_threads=2
+ CONFIG_do_monthly=01
+ CONFIG_do_weekly=5
+ CONFIG_rotation_daily=6
+ CONFIG_rotation_weekly=35
+ CONFIG_rotation_monthly=150
+ CONFIG_mysql_dump_port=3306
+ CONFIG_mysql_dump_usessl=yes
+ CONFIG_mysql_dump_username=root
+ CONFIG_mysql_dump_password=
+ CONFIG_mysql_dump_host=localhost
+ CONFIG_mysql_dump_host_friendly=
+ CONFIG_mysql_dump_socket=
+ CONFIG_mysql_dump_create_database=no
+ CONFIG_mysql_dump_use_separate_dirs=yes
+ CONFIG_mysql_dump_compression=gzip
+ CONFIG_mysql_dump_commcomp=no
+ CONFIG_mysql_dump_latest=no
+ CONFIG_mysql_dump_latest_clean_filenames=no
+ CONFIG_mysql_dump_max_allowed_packet=
+ CONFIG_mysql_dump_single_transaction=no
+ CONFIG_mysql_dump_master_data=
+ CONFIG_mysql_dump_full_schema=yes
+ CONFIG_mysql_dump_dbstatus=yes
+ CONFIG_mysql_dump_differential=no
+ CONFIG_backup_local_files=()
+ CONFIG_db_names=()
+ CONFIG_db_month_names=()
+ CONFIG_db_exclude=('information_schema')
+ CONFIG_table_exclude=()
+ CONFIG_mailcontent=stdout
+ CONFIG_mail_maxattsize=4000
+ CONFIG_mail_splitandtar=yes
+ CONFIG_mail_use_uuencoded_attachments=no
+ CONFIG_mail_address=root
+ CONFIG_encrypt=no
+ CONFIG_encrypt_password=password0123
+ trap mail_cleanup EXIT SIGHUP SIGINT SIGQUIT SIGTERM
+ [[ -r /etc/automysqlbackup/automysqlbackup.conf ]]
+ source /etc/automysqlbackup/automysqlbackup.conf
++ CONFIG_mysql_dump_username=[tiny]
++ CONFIG_mysql_dump_password=[tiny]
++ CONFIG_mysql_dump_host=[tiny]
++ CONFIG_backup_dir=/home/automysqlbackup
++ CONFIG_multicore=yes
++ CONFIG_multicore_threads=8
++ CONFIG_db_names=('[tiny]' '[tiny]' '[tiny]')
++ CONFIG_db_month_names=('[tiny]' '[tiny]' '[tiny]')
++ CONFIG_mailcontent=files
++ CONFIG_mail_maxattsize=99000
++ CONFIG_mail_splitandtar=yes
++ CONFIG_mail_address=[tiny]
++ CONFIG_encrypt=yes
++ CONFIG_encrypt_password=[tiny]
+ echo 'Parsed config file "/etc/automysqlbackup/automysqlbackup.conf"'
+ echo
+ (( ))
+ let 'N |= 8'
+ (( ))
+ export LC_ALL=C
+ LC_ALL=C
++ basename /usr/local/bin/automysqlbackup
+ PROGNAME=automysqlbackup
+ PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/bin:/usr/bin:/bin:/usr/local/mysql/bin
+ version=3.0
+ fields=5
+ directory_checks_enable_logging
+ checkdirs=("${CONFIG_backup_dir}"/{daily,weekly,monthly,latest,tmp})
+ [[ -n '' ]]
+ [[ yes = \y\e\s ]]
+ checkdirs=("${checkdirs[@]}" "${CONFIG_backup_dir}/fullschema")
+ [[ yes = \y\e\s ]]
+ checkdirs=("${checkdirs[@]}" "${CONFIG_backup_dir}/status")
+ tmp_permcheck=0
+ printf '# Checking for permissions to write to folders:\n'
++ dirname /home/automysqlbackup
+ printf 'base folder %s ... ' /home
++ dirname /home/automysqlbackup
+ [[ -d /home ]]
+ printf 'exists ... ok.\n'
+ printf 'backup folder %s ... ' /home/automysqlbackup
+ [[ -d /home/automysqlbackup ]]
+ printf 'exists ... writable? '
+ (( ))
+ chk_folder_writable /home/automysqlbackup
+ local temp
++ mktemp /home/automysqlbackup/tmp.XXXXXX
+ temp=/home/automysqlbackup/tmp.Hy5e93
+ (( 0 == 0 ))
+ rm /home/automysqlbackup/tmp.Hy5e93
+ return 0
+ printf 'yes. Proceeding.\n'
++ date +%N
+ log_file=/home/automysqlbackup/[tiny]-769663340.log
++ date +%N
+ log_errfile=/home/automysqlbackup/ERRORS_[tiny]-770823801.log
+ activateIO /home/automysqlbackup/[tiny]-769663340.log /home/automysqlbackup/ERRORS_[tiny]-770823801.log
+ touch /home/automysqlbackup/[tiny]-769663340.log
+ exec
+ exec
+ touch /home/automysqlbackup/ERRORS_[tiny]-770823801.log
+ exec
+ exec
+ [[ ! -e /home/automysqlbackup/[tiny]-769663340.log ]]
+ case "${CONFIG_mailcontent}" in
+ [[ -s /home/automysqlbackup/ERRORS_[tiny]-770823801.log ]]
+ backupfiles=("${backupfiles[@]}" "$log_errfile")
+ errornote='WARNING: Error Reported - '
++ mktemp /home/automysqlbackup/tmp/mail_content.XXXXXX
+ temp=/home/automysqlbackup/tmp/mail_content.8L2yEF
++ awk 'END {print $1}'
++ du -c /home/automysqlbackup/fullschema/fullschema_daily_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/status/status_daily_2012-09-17_01h59m_Monday.txt.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/ERRORS_[tiny]-770823801.log
+ attsize=1152
+ (( 99000 >= 1152 ))
+ [[ xno = \x\y\e\s ]]
+ mutt -s 'WARNING: Error Reported - MySQL Backup Log and SQL Files for [tiny] - 2012-09-17_01h59m' -a /home/automysqlbackup/fullschema/fullschema_daily_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/status/status_daily_2012-09-17_01h59m_Monday.txt.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/daily/[tiny]/daily_[tiny]_2012-09-17_01h59m_Monday.sql.gz.enc /home/automysqlbackup/ERRORS_[tiny]-770823801.log -- sored@o2.pl
+ rm /home/automysqlbackup/tmp/mail_content.8L2yEF
+ [[ -e /home/automysqlbackup/[tiny]-769663340.log ]]
+ rm -f /home/automysqlbackup/[tiny]-769663340.log
+ [[ -e /home/automysqlbackup/ERRORS_[tiny]-770823801.log ]]
+ rm -f /home/automysqlbackup/ERRORS_[tiny]-770823801.log

From error log:
mysqldump: Couldn't execute 'show create table `killchart`': SHOW VIEW command denied to user 'backup'@'[tiny]' for table 'killchart' (1142)

Why automysqldump want to execute: show create table `killchart`?!

Discussion