Public bug reported: mysqlhotcopy attempts to flush all tables, and when it gets to one of the views, it throws the error "<tablename> is not BASE TABLE" (this error was added in 5.5). This in turn causes the backup to abort.
ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: mysql-server 5.5.24-0ubuntu0.12.04.1 ProcVersionSignature: Ubuntu 3.2.0-25.40-generic 3.2.18 Uname: Linux 3.2.0-25-generic x86_64 ApportVersion: 2.0.1-0ubuntu8 Architecture: amd64 Date: Tue Jun 19 02:23:33 2012 InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425) Logs.var.log.daemon.log: Logs.var.log.kern.log: Jun 18 23:34:29 carl kernel: [351039.309278] type=1400 audit(1340087669.111:26): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=6412 comm="apparmor_parser" Jun 19 01:09:40 carl kernel: [356750.407056] type=1400 audit(1340093380.208:27): apparmor="STATUS" operation="profile_replace" name="/usr/sbin/mysqld" pid=7678 comm="apparmor_parser" MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: False PackageArchitecture: all ProcEnviron: TERM=xterm PATH=(custom, user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: mysql-5.5 UpgradeStatus: No upgrade log present (probably fresh install) ** Affects: mysql-server Importance: Unknown Status: Unknown ** Affects: mysql-5.5 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug precise -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1015033 Title: mysqlhotcopy errors on databases containing MyISAM views To manage notifications about this bug go to: https://bugs.launchpad.net/mysql-server/+bug/1015033/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs